private OleDbConnection GetConn()
{
Helper.Database.AccessHelper db = new Helper.Database.AccessHelper(ConnStr);
OleDbConnection conn = db.CreateConnection();
return(conn);
}
protected void Page_Load(object sender, EventArgs e)
{
Helper.Database.AccessHelper db = new Helper.Database.AccessHelper("c:\\iwms.mdb");
Helper.PageModel pm = db.GetPageModel("*", "iwms_news", "", "articleId", "asc", 10, 20);
Response.Write(pm.Page + "," + pm.Nextpage + "," + pm.Prevpage + "," + pm.TotalRecord + "," + pm.TotalPage + "," + pm.Pagesize + "<br/>");
DataTable dt = pm.List as DataTable;
foreach (DataRow dr in dt.Rows)
{
Response.Write("<br>" + dr["title"]);
}
}
private OleDbConnection GetConn()
{
Helper.Database.AccessHelper db = new Helper.Database.AccessHelper(ConnStr);
OleDbConnection conn = db.CreateConnection();
return conn;
}
public OledbHelper(string s)
{
this.ConnStr = s;
Helper.Database.AccessHelper db = new Helper.Database.AccessHelper(ConnStr);
conn = db.CreateConnection();
}
public OledbHelper(string s)
{
this.ConnStr = s;
Helper.Database.AccessHelper db = new Helper.Database.AccessHelper(ConnStr);
conn = db.CreateConnection();
}
