关于连接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=database

			connStr = 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();

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