c#连接sql数据库的一个处理类

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace shop.Tool
{
public class SQLTool
{
   private string SqlConString="server=(local);database=myshop;uid=sa;pwd=;";
   //System.Configuration.ConfigurationSettings.AppSettings["constring"].ToString()
   ///<summary>
   ///执行添删改sql语句的方法
   ///</summary>
   ///<param name="sql">
   ///</param>
   public bool ExecuteADU(string sql)
   {
    SqlConnection myconn=new SqlConnection(SqlConString);
         myconn.Open();
    SqlCommand mycomm=myconn.CreateCommand();
    mycomm.CommandText=sql;
    try
    {
     mycomm.ExecuteNonQuery();
     return true;
    }
    catch(ExceptionClass.ExceptionSql ex)
    {
     throw new ExceptionClass.ExceptionSql(ex.Message.ToString());
     return false;
    }
   }
   ///<summary>
   ///执行查询语句的方法
   ///</summary>
   ///<param name="sql">
   ///</param>
   public DataSet ExecuteSelect(string sql)
   {
    DataSet ds=new DataSet();
    try
    {
                SqlDataAdapter sda=new SqlDataAdapter(sql,SqlConString);
     sda.Fill(ds);   
    }
    catch(ExceptionClass.ExceptionSql ex)
    {
     throw new ExceptionClass.ExceptionSql(ex.Message.ToString());
    }
    return ds;
   }
   ///<summary>
   ///返回DataReader
   ///</summary>
   ///<param name="sql">
   ///</param>
   public SqlDataReader GetDataReader(string sql)
   {
    SqlConnection myconn=new SqlConnection(SqlConString);
    SqlDataReader mydatareader=null;
    myconn.Open();
    SqlCommand mycomm=myconn.CreateCommand();
    try
    {
     mydatareader=mycomm.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
    }
    catch(ExceptionClass.ExceptionSql ex)
    {
     throw new ExceptionClass.ExceptionSql(ex.Message.ToString());
    }
    finally
    {
     myconn.Close();
     mycomm.Dispose();
    }
            return mydatareader;
   }

   ///<summary>
   ///执行添删改(存储过程)
   ///</summary>
   ///<param name="proname"></param>
   ///<param name="sp"></param>
   ///<returns></returns>
  
   public bool ExecuteADU(string proname,SqlParameter [] sp)
   {
    SqlConnection myconn=new SqlConnection(SqlConString);
    myconn.Open();
    SqlCommand mycomm=myconn.CreateCommand();
    foreach(SqlParameter mypara in sp)
    {
     mycomm.Parameters.Add(mypara);
    }
    mycomm.CommandType=CommandType.StoredProcedure;
    mycomm.CommandText=proname;
    try
    {
     mycomm.ExecuteNonQuery();
     return true;
    }
    catch(ExceptionClass.ExceptionSql ex)
    {
     throw new ExceptionClass.ExceptionSql(ex.Message.ToString());
     return false;
    }
    finally
    {
     myconn.Close();
     mycomm.Dispose();
    }
   }
   ///<summary>
   ///执行查询语句(存储过程)
   ///</summary>
   ///<param name="proname"></param>
   ///<param name="sp"></param>
   ///<returns></returns>
   public DataSet ExecuteSelect(string proname,SqlParameter []sp)
   {
    DataSet myds=new DataSet();
    SqlDataAdapter mysda;
    SqlConnection myconn=new SqlConnection(SqlConString);
    myconn.Open();
    SqlCommand mycomm=myconn.CreateCommand();
    foreach(SqlParameter mypara in sp)
    {
     mycomm.Parameters.Add(mypara);
    }
            mycomm.CommandType=CommandType.StoredProcedure;
    mycomm.CommandText=proname;
   
    try
    {
     mysda=new SqlDataAdapter(proname,myconn);
     mysda.SelectCommand=mycomm;
     mysda.Fill(myds);
    }
    catch(ExceptionClass.ExceptionSql ex)
    {
     throw new ExceptionClass.ExceptionSql(ex.Message.ToString());
    }
    finally
    {
     myconn.Close();
     mycomm.Dispose();
    }
    return myds;
   }
   ///<summary>
   ///返回单行单列的值
   ///</summary>
   ///<param name="sql">
   ///</param>
   ///<returns></returns>
   public object GetSingleData(string sql)
   {   object ob;
    SqlConnection myconn=new SqlConnection(SqlConString);
    myconn.Open();
            SqlCommand mycomm=myconn.CreateCommand();
    mycomm.CommandText=sql;
    try
    {
     ob=mycomm.ExecuteScalar();
    }
    catch(ExceptionClass.ExceptionSql ex)
    {
     throw new ExceptionClass.ExceptionSql(ex.Message.ToString());
    }
    finally
    {
     myconn.Close();
     mycomm.Dispose();
    }
    return ob;
   }
}
}

原文地址