一个项目我一般只用一个数据库,现在有需求,需要使用多个数据库,临时改了一下,不知道好不好,请高手指教,大家使用多数据库的时候是如何切换的。
DBHelper.cs
Copy to Clipboard
引用的内容:[www.veryhuo.com]
private static string connectionString = "SQLCONNECTIONSTRING";
///
///
public static void SetSqlConnection(string connStr)
{
connectionString = connStr;
}
///
///
public static String GetSqlConnection()
{
String conn = ConfigurationManager.AppSettings[connectionString].ToString();
return conn;
}
///
///SQL语句
///参数对象数组
///
public static int ExecuteSql(String Sqlstr, SqlParameter[] param)
{
String ConnStr = GetSqlConnection();
using (SqlConnection conn = new SqlConnection(ConnStr))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = Sqlstr;
cmd.Parameters.AddRange(param);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return 1;
}
}
Test.cs(BLL)
Copy to Clipboard
引用的内容:[www.veryhuo.com]
using System;
using System.Collections.Generic;
using System.Linq;
using System.Data;
using System.Configuration;
using System.Web;
using HY.Common;
using System.Text;
using System.Data.SqlClient;
namespace HY.BLL
{
public class Test
{
///
static Test()
{
DBHelper.SetSqlConnection("SQLCONNECTIONSTRING");
}
///
///
public static DataTable getAll()
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from t_Users");
return DBHelper.ExecuteDt(sb.ToString());
}
///
///
public static DataTable getTable()
{
DBHelper.SetSqlConnection("SQLCONNECTIONSTRING1");//BLL中这样切换
StringBuilder sb = new StringBuilder();
sb.Append("select * from t_User");
return DBHelper.ExecuteDt(sb.ToString());
}
}
}
web.config
Copy to Clipboard
引用的内容:[www.veryhuo.com]
SqlTest.aspx.cs
Copy to Clipboard
引用的内容:[www.veryhuo.com]
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
Bind();
}
private void Bind()
{
//切换数据库的操作封装在BLL中
GridView1.DataSource = Test.getAll();
GridView1.DataBind();
//切换数据库
GridView2.DataSource = Test.getTable();
GridView2.DataBind();
}
完整代码:/Files/greatverve/MyFiles.rar