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(); }