62,074
社区成员
发帖
与我相关
我的任务
分享
static SqlConnection conn;
//添加参数
public static SqlConnection GetConnection(string strConnnectionString)//这个地方传入你需要用的连接字串
{
//获取所有配置信息
NameValueCollection coll = ConfigurationSettings.AppSettings;
//配置信息的键数组
string[] keys = coll.AllKeys;
string str = null;
switch (strConnnectionString)//里面怎么写 我连接的多个库key
{
case "ConnString":
str = ConnectionString1;
break;
case "ConnString1":
str = ConnectionString2;
break;
case "ConnString2":
str = ConnectionString3;
break;
}
return conn = new SqlConnection(str);
}
//这样就调用了 ConnString1的数据了!
ExecuteUpdate("delete from 表名 where id=12 ","ConnString1");
static string ConnectionString1 = System.Configuration.ConfigurationSettings.AppSettings["ConnString"].ToString();
static string ConnectionString2 = System.Configuration.ConfigurationSettings.AppSettings["ConnString1"].ToString();
static string ConnectionString3 = System.Configuration.ConfigurationSettings.AppSettings["ConnString2"].ToString();
static SqlConnection conn;
public static SqlConnection GetConnection(string strkey)
{
//获取所有配置信息
//NameValueCollection coll = ConfigurationSettings.AppSettings;
//配置信息的键数组
//string[] keys = coll.AllKeys;
//string str = null;
switch (strkey)//里面怎么写 我连接的多个库key
{
case "ConnString":
str = ConnectionString1;
break;
case "ConnString1":
str = ConnectionString2;
break;
case "ConnString2":
str = ConnectionString3;
break;
}
return conn = new SqlConnection(str);
}
/// <summary>
/// 执行增删改
/// </summary>
/// <param name="sql"></param>
/// <param name="strkey">这个就是你要传是那个数据库了</param>
/// <returns></returns>
public static bool ExecuteUpdate(string sql,string strkey)
{
GetConnection(strkey);
try
{
using (SqlCommand comm = new SqlCommand(sql,conn))
{
conn.Open();
int i = comm.ExecuteNonQuery();
return i > 0;
}
}
catch
{
conn.Close();
return false;
}
}
string[] keys = coll.AllKeys;
string str = null;
switch (keys[0]or keys[1] or keys[2])//里面怎么写 我连接的多个库key
{
case "ConnString":
str = ConnectionString1;
break;
case "ConnString1":
str = ConnectionString2;
break;
case "ConnString2":
str = ConnectionString3;
break;
}