private void showgrid(object sender, System.EventArgs e) { DataTable mydt = null; mydt = AccessDb.Execute("select * from t_news where ptype='" + typ + "' order by id desc").Tables[0]; DGList.DataSource = mydt; DataTable dt = new DataTable(); try { DGList.DataBind(); MyPage1.init(mydt.Rows.Count); } catch { if ((DGList.CurrentPageIndex - 1) >= 0) { DGList.CurrentPageIndex = DGList.CurrentPageIndex - 1; } DGList.DataBind(); MyPage1.init(mydt.Rows.Count); } }
private void showgrid(object sender, System.EventArgs e) { DataTable mydt = null; mydt = AccessDb.Execute("select * from t_question order by pAnswered ,pdate desc").Tables[0]; DGList.DataSource = mydt; try { DGList.DataBind(); MyPage1.init(mydt.Rows.Count); } catch { if ((DGList.CurrentPageIndex - 1) >= 0) { DGList.CurrentPageIndex = DGList.CurrentPageIndex - 1; } DGList.DataBind(); MyPage1.init(mydt.Rows.Count); } }