工作常用的操縱資料庫的C#類

 

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>
/// db 的摘要說明
/// </summary>
public class db
{
 public db()
 {
  //
  // TODO: 在此處添加建構函式邏輯
  //
 }
    public static SqlConnection createConnection()
    {
        SqlConnection con = new SqlConnection("Data Source=IP地址;Initial Catalog=資料庫名;Persist Security Info=True;User ID=使用者;Password=密碼");
        return con;
   
    }
    public int ExecSql(string Sql)
    {
        string constr = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
        SqlConnection myConnection = new SqlConnection(constr);
        SqlCommand cmd = new SqlCommand(Sql, myConnection);
        myConnection.Open();
        int ret = (int)cmd.ExecuteNonQuery();
        myConnection.Close();
        return ret;
    }
    public void Exec(string Sql)
    {//執行SQL語句
        string constr = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
        SqlConnection myConnection = new SqlConnection(constr);
        SqlCommand cmd = new SqlCommand(Sql, myConnection);
        myConnection.Open();
        cmd.ExecuteNonQuery();
        myConnection.Close();
    }

    //執行SqlDataReader
    public SqlDataReader GetReader(string Sql)
    {
        string constr = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
        SqlConnection conn = new SqlConnection(constr);
        SqlCommand cmd = new SqlCommand(Sql, conn);
        conn.Open();
        SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
        return dr;
    }

    //執行DataSet加入到資料集
    public DataSet GetDatSet(string Sql)
    {
        string constr = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
        SqlConnection myConnection = new SqlConnection(constr);
        SqlDataAdapter da = new SqlDataAdapter(Sql, myConnection);
        DataSet ds = new DataSet();
        myConnection.Open();
        da.Fill(ds);
        myConnection.Close();
        return ds;
    }

================webConfig的設定檔=====================

<appSettings>
    <add key="ConnectionString" value="server=IP地址;database=庫;uid=使用者;Password=密碼;"/>
  </appSettings>