?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;
//該源碼下載自www.51aspx.com(５１aｓpｘ．ｃｏｍ)

/// <summary>
/// 數據庫操作類
/// </summary>
public class DataBase
{
    private string _connstr=ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
    public SqlConnection objConn;
    private SqlCommand Cmd = null;
    private SqlDataAdapter Da = null;
    private DataSet Ds = null;
    private DataTable Dt = null;
	public DataBase()
	{
        //實例化objConn 連接
        objConn = new SqlConnection(_connstr);
	}
    /// <summary>
    /// Sql Server ---- 連接字符串
    /// </summary>
    public string ConnStr
    {
        get { return _connstr; }
        set { _connstr = value; }
    }
    /// <summary>
    ///傳入參數  執行并返回 SqlCommand 命令 
    /// </summary>
    /// <param name="Sqlstr">Sql字符串</param>
    /// <param name="parms">參數</param>
    /// <returns></returns>
    protected SqlCommand ExecuteCmd(string Sqlstr,SqlParameter[] parms)
    {
        Cmd = new SqlCommand(Sqlstr,objConn);
        foreach(SqlParameter parm in parms)
        {
            Cmd.Parameters.Add(parm);
        }
        return Cmd;
    }
    protected SqlCommand ExecuteCmd(string Sqlstr)
    {
        Cmd = new SqlCommand(Sqlstr, objConn);
        return Cmd;
    }
    protected SqlDataAdapter ExecuteDataAdpter(string Sqlstr)
    {
        Da = new SqlDataAdapter(Sqlstr, objConn);
        return Da;
    }
    /// <summary>
    /// 返回 DataSet
    /// </summary>
    /// <param name="Cmd"></param>
    /// <returns></returns>
    protected DataSet ExecuteDataSet(SqlCommand Cmd)
    {
        Da = new SqlDataAdapter();
        Da.SelectCommand = Cmd;
        Ds = new DataSet();
        Da.Fill(Ds);
        return Ds;
    }
    /// <summary>
    /// 返回 DataTable
    /// </summary>
    /// <param name="Cmd"></param>
    /// <returns></returns>
    protected DataTable ExecuteDataTable(SqlCommand Cmd)
    {
        Da = new SqlDataAdapter();
        Da.SelectCommand = Cmd;
        Dt = new DataTable();
        Da.Fill(Dt);
        return Dt;
    }
}