AspNetPager+GridView+Access分页示例

1. using System;
2. using System.Data;
3. using System.Configuration;
4. using System.Collections;
5. using System.Web;
6. using System.Web.Security;
7. using System.Web.UI;
8. using System.Web.UI.WebControls;
9. using System.Web.UI.WebControls.WebParts;
10. using System.Web.UI.HtmlControls;
11. using System.Data.OleDb;
13. public partial class GuanLi_yonghu_gl : System.Web.UI.Page
14. {
15.     OleDbConnection conn;
16.     OleDbCommand cmd;
17.     protected void Page_Load(object sender, EventArgs e)
18.     {
19.         conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("mdb//jiuzhou.mdb"));
20.         if (!Page.IsPostBack)
21.         {
22.             cmd = new OleDbCommand("SELECT COUNT(*) FROM [guest] ", conn);
23.             conn.Open();
24.             AspNetPager1.RecordCount = (int)cmd.ExecuteScalar();
25.             conn.Close();
26.             BindData();
27.         }
28.     }
29.     void BindData()
30.     {
31.         cmd = new OleDbCommand("SELECT * FROM [guest] ORDER BY [naneID] DESC", conn);
32.         OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
33.         DataSet ds = new DataSet();
34.         adapter.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "naneID");
35.         GridView1.DataSource = ds.Tables["naneID"];
36.         GridView1.DataBind();
37.     }
39.     protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
40.     {
41.         AspNetPager1.CurrentPageIndex = e.NewPageIndex;
42.         BindData();
43.     }
44. }

aspx.cs页面