当前文件： SimpleUserManager/App_Code/DataBase.cs[2K，2009-6-12 11:54:09]，打开代码结构图

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Web;
 5using System.Web.Security;
 6using System.Web.UI;
 7using System.Web.UI.WebControls;
 8using System.Web.UI.WebControls.WebParts;
 9using System.Web.UI.HtmlControls;
10using System.Data.SqlClient;
11//该源码下载自www.51aspx.com(５１aｓpｘ．ｃｏｍ)
12
13/**//// <summary>
14/// 数据库操作类
15/// </summary>
16public class DataBase
17...{
18    private string _connstr=ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
19    public SqlConnection objConn;
20    private SqlCommand Cmd = null;
21    private SqlDataAdapter Da = null;
22    private DataSet Ds = null;
23    private DataTable Dt = null;
24    public DataBase()
25    ...{
26        //实例化objConn 连接
27        objConn = new SqlConnection(_connstr);
28    }
29    /**//// <summary>
30    /// Sql Server ---- 连接字符串
31    /// </summary>
32    public string ConnStr
33    ...{
34        get ...{ return _connstr; }
35        set ...{ _connstr = value; }
36    }
37    /**//// <summary>
38    ///传入参数  执行并返回 SqlCommand 命令 
39    /// </summary>
40    /// <param name="Sqlstr">Sql字符串</param>
41    /// <param name="parms">参数</param>
42    /// <returns></returns>
43    protected SqlCommand ExecuteCmd(string Sqlstr,SqlParameter[] parms)
44    ...{
45        Cmd = new SqlCommand(Sqlstr,objConn);
46        foreach(SqlParameter parm in parms)
47        ...{
48            Cmd.Parameters.Add(parm);
49        }
50        return Cmd;
51    }
52    protected SqlCommand ExecuteCmd(string Sqlstr)
53    ...{
54        Cmd = new SqlCommand(Sqlstr, objConn);
55        return Cmd;
56    }
57    protected SqlDataAdapter ExecuteDataAdpter(string Sqlstr)
58    ...{
59        Da = new SqlDataAdapter(Sqlstr, objConn);
60        return Da;
61    }
62    /**//// <summary>
63    /// 返回 DataSet
64    /// </summary>
65    /// <param name="Cmd"></param>
66    /// <returns></returns>
67    protected DataSet ExecuteDataSet(SqlCommand Cmd)
68    ...{
69        Da = new SqlDataAdapter();
70        Da.SelectCommand = Cmd;
71        Ds = new DataSet();
72        Da.Fill(Ds);
73        return Ds;
74    }
75    /**//// <summary>
76    /// 返回 DataTable
77    /// </summary>
78    /// <param name="Cmd"></param>
79    /// <returns></returns>
80    protected DataTable ExecuteDataTable(SqlCommand Cmd)
81    ...{
82        Da = new SqlDataAdapter();
83        Da.SelectCommand = Cmd;
84        Dt = new DataTable();
85        Da.Fill(Dt);
86        return Dt;
87    }
88}
89