网上载的,简单使用。
反射获取dbConn类中的方法
public static SqlConnection GetConnection(string id)//创建连接,由参数决定调用哪个连接字符串
{
dbConn mydbcon = new dbConn();
Type myType = mydbcon.GetType();
System.Reflection.PropertyInfo myPI = myType.GetProperty("ConnectionString"+id);
SqlConnection connection = new SqlConnection(myPI.GetValue(mydbcon, null).ToString());
connection.Open();
return connection;
}
dbConn类:
public class dbConn
{
#region 从配置文件web.config中取得sqlserver连接字符串 ConnectionString
public string ConnectionString1
{
get { return ConfigurationManager.ConnectionStrings["SQLConnString1"].ConnectionString; }
}
public string ConnectionString2
{
get { return ConfigurationManager.ConnectionStrings["SQLConnString2"].ConnectionString; }
}
#endregion
}