Question

如何在Visual Studio 2010中使用SQL Server 2008

Answer 1

首先建立一个DBHelper类 把这些代码做下修改 class DBHelper { // 数据库连接字符串 private string connString = "Data Source=你电脑服务器名称;Initial Catalog=要连接的数据库名称;User ID=sa;Pwd=你安装数据库设置的密码"; // 数据库连接 Connection 对象 private SqlConnection connection; /// <summary> /// Connection对象 /// </summary> public SqlConnection Connection { get { if (connection == null) { connection = new SqlConnection(connString); } return connection; } } /// <summary> /// 打开数据库连接 /// </summary> public void OpenConnection() { if (Connection.State == ConnectionState.Closed) { Connection.Open(); } else if (Connection.State == ConnectionState.Broken) { Connection.Close(); Connection.Open(); } } /// <summary> /// 关闭数据库连接 /// </summary> public void CloseConnection() { if (Connection.State == ConnectionState.Open Connection.State == ConnectionState.Broken) { Connection.Close(); } } 然后在你需要连接数据库的地方实例化DBHelper 类