- using System;
- using System.Data;
- using System.Configuration;
- using System.Collections;
- using System.Web;
- using System.Web.Security;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Web.UI.WebControls.WebParts;
- using System.Web.UI.HtmlControls;
- using System.Data.OleDb;
- public partial class GuanLi_yonghu_gl : System.Web.UI.Page
- {
- OleDbConnection conn;
- OleDbCommand cmd;
- protected void Page_Load(object sender, EventArgs e)
- {
- conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("mdb//jiuzhou.mdb"));
- if (!Page.IsPostBack)
- {
- cmd = new OleDbCommand("SELECT COUNT(*) FROM [guest] ", conn);
- conn.Open();
- AspNetPager1.RecordCount = (int)cmd.ExecuteScalar();
- conn.Close();
- BindData();
- }
- }
- void BindData()
- {
- cmd = new OleDbCommand("SELECT * FROM [guest] ORDER BY [naneID] DESC", conn);
- OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
- DataSet ds = new DataSet();
- adapter.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "naneID");
- GridView1.DataSource = ds.Tables["naneID"];
- GridView1.DataBind();
- }
- protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
- {
- AspNetPager1.CurrentPageIndex = e.NewPageIndex;
- BindData();
- }
- }
aspx.cs页面