自己写的一个c#操作sql server 2000数据库的连接类

先在web.config里面加入
<appSettings>
<add key="sqlConn" value="data source=(local); initial catalog=02wangluo;user id=sa; password="/>
</appSettings>
然后
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using System.Configuration;
namespace DoDataBase
{
 /// <summary>
 /// DoDataBase 的摘要说明。
 /// </summary>
 public class DoDataBase
 {
  public DoDataBase()
  {
   //
   // TODO: 在此处添加构造函数逻辑
   //
  }
  
  private static SqlConnection sqlConn = new SqlConnection(ConfigurationSettings.AppSettings["sqlConn"]);
  public static String sql="";
        public static DataSet dtset=null;
  public static String txtSQL
  {
   get
   {
                return sql;
   }
   set
   {
               sql=value;
   }
  }
  public static DataSet DBSet
  {
   get
   {
    return dtset;
   }
   set
   {
                dtset=value;
   }
  }
  public static DataSet ExecuteSQL(string strSQL)
  {
   DataSet ds = new DataSet(); 
   try
   {
    string[] SplitSQL = strSQL.Split();
    if(SplitSQL[0].ToUpper()=="SELECT") 
    {
     
     SqlDataAdapter sqlApt =new SqlDataAdapter(strSQL, sqlConn);    
     sqlApt.Fill(ds);
     return ds;
    }
    else
    {
     SqlCommand sqlCmd =new SqlCommand(strSQL,sqlConn);
     sqlConn.Open();
     sqlCmd.ExecuteNonQuery();
     return null;
    }

   }
   catch (Exception ex)
   {
    throw (ex);  
   }

   finally
   {
    sqlConn.Close();
   }
  }

 }
}
感觉捕获异常和关闭数据库那块写的不是很好,有时间会再修改一下
修改如下:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using System.Configuration;
namespace DoDataBase
{
 /// <summary>
 /// DoDataBase 的摘要说明。
 /// </summary>
 public class DoDataBase
 {
  public DoDataBase()
  {
   //
   // TODO: 在此处添加构造函数逻辑
   //
  }  
  private static SqlConnection sqlConn = new SqlConnection(ConfigurationSettings.AppSettings["sqlConn"]);
  private static SqlDataAdapter sqlApt=null;
        private static SqlCommand sqlCmd=null;
  public static String sql="";
        public static DataSet dtset=null;
  public static String txtSQL
  {
   get
   {
                return sql;
   }
   set
   {
               sql=value;
   }
  }
  public static DataSet DBSet
  {
   get
   {
    return dtset;
   }
   set
   {
                dtset=value;
   }
  }
  public static DataSet ExecuteSQL(string strSQL)
  {
   DataSet ds = new DataSet(); 
   try
   {
    string[] SplitSQL = strSQL.Split();
    if(SplitSQL[0].ToUpper()=="SELECT") 
    {
     
     sqlApt =new SqlDataAdapter(strSQL, sqlConn);    
     sqlApt.Fill(ds);
     return ds;
    }
    else
    {
     sqlCmd =new SqlCommand(strSQL,sqlConn);
     sqlConn.Open();
     sqlCmd.ExecuteNonQuery();
     return null;
    }

   }
   catch (Exception ex)
   {
    throw (ex);  
   }

   finally
   {     
    CloseConnection();
   }
  }
  private static void CloseConnection()
  {
   // 关闭Command
   if (sqlCmd != null)
   {
    sqlCmd.Dispose();
   }
   //关闭数据适配器
   if(sqlApt!=null)
   {
                sqlApt.Dispose();
   }
   // 关闭连接
   if (sqlConn.State == ConnectionState.Open)
   {
          sqlConn.Close();
   }
  }
 }
}