C#数据库操作类类DB_Class

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

/// <summary>

/// Sql_Class 的摘要说明

/// </summary>

public class DB_Class

{

    public DB_Class()

{

   //

   // TODO: 在此处添加构造函数逻辑

   //

    }

    # region GetCon

    public static SqlConnection GetCon()

    {

        return new SqlConnection(ConfigurationManager.AppSettings[ "GetCon"]);

    }

    # endregion

    # region insert/del/update

    //~~~~~~~~~~~~~~~~~~~~~~根据传进来的ＳＱＬ语句执行插入/删除/更新等操作~~~~~~~~~~~~~~~~~~~~~~~~~

    public static bool doData(string que)

    {

        SqlConnection con = GetCon();

        con.Open();

        SqlCommand cmd = new SqlCommand(que, con);

        try

        {

            cmd.ExecuteNonQuery();

            return true;

        }

        catch

        {

            return false;

        }

        finally

        {

            cmd.Dispose();

            con.Dispose();

        }

    }

    #endregion

    # region return_single_data

    //~~~~~~~~~~~~~~~~~~~~~~~~~~~查询返回单个字段~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    public static String return_single_data(string cmdText)

    {

        SqlConnection con = GetCon();

        con.Open();

        SqlCommand cmd = new SqlCommand(cmdText, con);

        String cn = null;

        try

        {           

            cn = cmd.ExecuteScalar().ToString();

            return cn;

        }

        catch

        {

            cn = "0";

            return cn;

        }

        finally

        {

            cmd.Dispose();

            con.Dispose();

        }        

    }

#endregion

    # region return_multi_data

    //~~~~~~~~~~~~~~~~~~~~~~~~~~~查询返回多条记录~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    public SqlDataReader return_multi_data(string cmdText)

    {

        SqlConnection con = GetCon();

        ///打开链接

        con.Open();

        ///创建Command

        SqlCommand myCommand = new SqlCommand(cmdText, con);

        ///定义DataReader

        SqlDataReader dr = null;

        try

        {

            ///读取数据

            dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);

            return dr;

        }

        catch (SqlException ex)

        {

            ///抛出异常

            throw new Exception(ex.Message, ex);

        }

        finally

        {

            ///返回DataReader

            con.Dispose();

        }

    }

    # endregion

    # region return_bool

    //~~~~~~~~~~~~~~~~~~~~~~~查询返回BOOL~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    public static bool check_name(string sql)

    {

        string temp;

        SqlConnection con = GetCon();

        SqlCommand cmd = new SqlCommand(sql, con);

         con.Open();

        try

        {

            temp = cmd.ExecuteScalar().ToString();

        }

        catch

        {

            return false;

        }

        if ((temp != "") && (temp != null))

            return true;

        else

            return false;

     }

    #endregion

     # region get_dataset

     //~~~~~~~~~~~~~~~~~~~~~~~~~~~DataSet查询返回多条记录~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    public DataSet GetDataSet(string strSql, string TableName)

    {

        SqlConnection con = GetCon();//与数据库连接

        con.Open();

        DataSet ds = new DataSet();

        SqlDataAdapter adapt = new SqlDataAdapter(strSql, con); //实例化SqlDataAdapter类对象

        try

        {

            adapt.Fill(ds, TableName);//填充数据集

            return ds;//返回数据集DataSet的表的集合

        }

        catch (Exception ex)

        {

            throw new Exception(ex.Message, ex);

        }

        finally

        {//断开连接，释放资源

            adapt.Dispose();

            ds.Dispose();

            con.Dispose();

            con.Close();

        }

    }

     #endregion

}