关于连接Sqlserver

早期的时候还不知道SqlHelper.cs，就自己写的一个简单的连接sqlserver的类，我连接的是sqlserver2000。

using System;using System.Data;using System.Data.SqlClient;namespace WindowsApplication1.CS{/// <summary>/// SQConn 的摘要说明。/// </summary>public class SQConn{protected SqlConnection conn = null;protected string connStr = ""; public SQConn(){//这里读取App.config文件的数据库连接串//串格式：server=127.0.0.1;uid=name;pwd=password;database=databaseconnStr = System.Configuration.ConfigurationSettings.AppSettings["DBConnectionString"].ToString();this.dbConnection();}       public SQConn(string connStr){this.connStr = connStr;this.dbConnection();}public SQConn(string server,string user,string psw,string db){this.connStr = "server=" + server + ";uid=" + user + ";pwd=" + psw + ";database=" + db ;this.dbConnection();}public DataSet GetDataSet (String sql){this.dbConnection();DataSet ds = new DataSet();SqlCommand cmd = new SqlCommand(sql,this.conn);SqlDataAdapter adpter = new SqlDataAdapter();adpter.SelectCommand = cmd;adpter.Fill(ds);this.dbClose();return ds;}protected void dbConnection(){if(this.conn == null){this.conn = new SqlConnection(this.connStr);this.conn.Open();}}public void dbClose(){if(this.conn != null){this.conn.Close();}}public DataSet exeQuery(string sql){SqlCommand cmd = new SqlCommand(sql,this.conn);DataSet ds = new DataSet();SqlDataAdapter adpter = new SqlDataAdapter();adpter.SelectCommand = cmd;adpter.Fill(ds);return ds;}public int exeUpdate(string sql){//log.Debug(sql);SqlCommand cmd = new SqlCommand(sql,this.conn);return cmd.ExecuteNonQuery();}}}

调用的时候也很方便：

SQConn _conn = new SQConn();

DataSet ds = new DataSet();

string sql = "select * from table1";

ds = _conn.exeQuery(sql);

//数据处理......

ds = null;

_conn.dbClose();

还请大家多多指教。^_^