演示环境为:Access+ASP.net; by:梦想oO天堂
- protected void Page_Load(object sender, EventArgs e)
- {
- if (!IsPostBack)
- {
- BindDataList();
- }
- }
- private void BindDataList()
- {
- OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OleDB.4.0;" + "Data Source=" + Server.MapPath("~/test.mdb"));
- con.Open();
- string sqlstr = "select * from _user";
- OleDbDataAdapter da = new OleDbDataAdapter(sqlstr, con);
- DataSet ds = new DataSet();
- da.Fill(ds, "user");
- //创建分页类
- PagedDataSource page = new PagedDataSource();
- //设置数据源
- page.DataSource = ds.Tables[0].DefaultView;
- //在数据绑定控件中启用分页
- page.AllowPaging = true;
- //分页显示的行数
- page.PageSize = 6;
- //定义变量保存当前页索引
- int curpage = Convert.ToInt32(nowpage.Text);
- //判断当前页是否有跳转请求
- page.CurrentPageIndex = curpage - 1;
- firstpage.Enabled = true;
- frontpage.Enabled = true;
- nextpage.Enabled = true;
- lastpage.Enabled = true;
- if (curpage == 1) //如果是第一页,首页和上一页失效
- {
- firstpage.Enabled = false;
- frontpage.Enabled = false;
- }
- if (curpage == page.PageCount)//如果是最后一页,下一页和最后一页失效
- {
- nextpage.Enabled = false;
- lastpage.Enabled = false;
- }
- nowpage.Text = curpage.ToString();//当前页
- countpage.Text = page.PageCount.ToString();//总页数
- DataList1.DataSource = page;//绑定页
- DataList1.DataBind();
- }
- protected void firstpage_Click(object sender, EventArgs e)
- { //首页代码
- nowpage.Text = "1";
- BindDataList();
- }
- protected void frontpage_Click(object sender, EventArgs e)
- { //上一页代码
- if (Convert.ToInt32(nowpage.Text)>1)
- {
- nowpage.Text = (Convert.ToInt32(nowpage.Text) - 1).ToString();
- }
- BindDataList();
- }
- protected void nextpage_Click(object sender, EventArgs e)
- { //下一页代码
- if (Convert.ToInt32(nowpage.Text) <Convert.ToInt32(countpage.Text))
- {
- nowpage.Text = (Convert.ToInt32(nowpage.Text) + 1).ToString();
- }
- BindDataList();
- }
- protected void lastpage_Click(object sender, EventArgs e)
- { //最后一页代码
- nowpage.Text = countpage.Text;
- BindDataList();
- }
转载于:https://blog.51cto.com/lionkas/1088669