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/**//// <summary>
12/// attendece 的摘要说明
13/// </summary>
14public class attendece
15...{
16    //先申明一系列常用的对象
17    private string connstr;
18    private SqlConnection Sqlconn;
19    private SqlCommand Sqlcmd;
20    private SqlDataAdapter Sqladpter;
21    private DataSet ds;
22    private SqlDataReader Sqlreader;
23    
24    public attendece()
25    ...{//初始化所有的实例
26        connstr = ConfigurationManager.ConnectionStrings["Mispersonalconn"].ConnectionString;
27        Sqlconn = new SqlConnection(connstr);
28        Sqlcmd = new SqlCommand();
29        Sqladpter = new SqlDataAdapter();
30        ds = new DataSet();
31    }
32    public SqlDataReader List(string sql)
33    ...{
34        Sqlcmd.CommandText = sql;
35        Sqlcmd.Connection = Sqlconn;
36        if (Sqlconn.State == ConnectionState.Closed) ...{ Sqlconn.Open(); }
37        Sqlreader = Sqlcmd.ExecuteReader(CommandBehavior.CloseConnection);
38        return Sqlreader;
39    }
40}
41