DA_Admin.csusing System;
using System.Data;
using System.Data.OleDb;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;//using Db;namespace Db
{
// <summary>
// View 的摘要说明。
// </summary>
public class View : System.Web.UI.Page 
{
protected System.Web.UI.WebControls.DataList Message;
protected System.Web.UI.WebControls.Label lbRecordCount;
protected System.Web.UI.WebControls.Label lbCurrentPage;
protected System.Web.UI.WebControls.Label lbPageCount;
protected System.Web.UI.WebControls.LinkButton butPrev;
protected System.Web.UI.WebControls.LinkButton butNext;
protected System.Web.UI.WebControls.DropDownList dlsPageIndex;

#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{    
this.Load += new System.EventHandler(this.Page_Load); }
#endregion

private void Page_Load(object sender, System.EventArgs e)
{
 string SQL;
 OleDbDataReader myDR;
 
 SQL="select product.*";
       SQL= SQL + " from [product]";
       SQL= SQL + " order by ParentID,iOrder";
  
       myDR = Db.BaseClass.dataReader(SQL);
       Message.DataSource=myDR;
       Message.DataBind(); 
}
}
}DB.CSusing System;
using System.Data;
using System.Data.OleDb;
using System.Configuration; namespace Db 

    public class BaseClass 
    { 
        public BaseClass( ) 
        { 
            // 
            // TODO: 在此处添加构造函数逻辑 
            // 
        } 
                
        protected static OleDbConnection conn ; 
        protected static OleDbCommand cmd = new OleDbCommand(); 
        protected static OleDbDataAdapter da = new OleDbDataAdapter(); 
        protected static DataSet ds = new DataSet( ); 
        protected static DataView dv = new DataView( ); 
        protected static string strSp;         // <summary>
        //  打开数据库连接 
        // </summary>
        public void openConnection()
        {
          if (conn.State == ConnectionState.Closed)
          {
            //读取webconfig中连接字符串,如:"server=localhost;database=databasename;uid=sa;pwd=;"           
            conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\ASP.NET\\work\\0\\DB\\db.mdb";
            cmd.Connection =conn;
            try
            {
              conn.Open();
            }
            catch(Exception e)
            {
              throw new Exception(e.Message);
            }
          }
        }
          
        // <summary>
        // 关闭当前数据库连接
        // </summary>
                
        // <summary>
        // 执行Sql查询语句
        // </summary>
        // <param name="sqlstr">传入的Sql语句</param>
        public  void ExecuteSql(string sqlstr)
        {
          try
          {
            openConnection();
            cmd.CommandType =CommandType.Text ;
            cmd.CommandText =sqlstr;
            cmd.ExecuteNonQuery(); 
          }
          catch(Exception ex)
          {
            throw new Exception(ex.Message);
          }
          finally
          {
            //closeConnection();
          }
        }
        
        /// <summary>
        /// 返回指定Sql语句的OleDbDataReader,请注意,在使用后请关闭本对象,同时将自动调用closeConnection()来关闭数据库连接
        /// 方法关闭数据库连接
        /// </summary>
        /// <param name="sqlstr">传入的Sql语句</param>
        /// <returns>OleDbDataReader对象</returns>
        public OleDbDataReader dataReader(string sqlstr)
        {
        OleDbDataReader dr=null;
        try
        {
          openConnection();
          cmd.CommandText =sqlstr;
          cmd.CommandType =CommandType.Text ;
          dr=cmd.ExecuteReader(CommandBehavior.CloseConnection); 
          }
        catch
        {
        try
        {
          dr.Close();
          //closeConnection();
        }
        catch
        {
        }
        }
          return dr;
        }   
   }
}