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

}