Repeater控件分页

最新推荐文章于 2018-06-01 15:45:48 发布

zhan198271

最新推荐文章于 2018-06-01 15:45:48 发布

阅读量566

点赞数

分类专栏： ASP.NET 文章标签： server border dataset asp object xhtml

本文链接：https://blog.csdn.net/zhan198271/article/details/2357101

版权

ASP.NET 专栏收录该内容

37 篇文章 0 订阅

订阅专栏

HTML代码:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

cs代码:

using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        dlBind();
    }
    public void dlBind()
    {
        int curpage = Convert.ToInt32(this.lblCurPage.Text);
        OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|data.mdb");
        //先定义一个PageDataSource,分页全靠它
        PagedDataSource ps = new PagedDataSource();
        myConn.Open();
        //定义一个OleDbDataAdapter
        OleDbDataAdapter myAdapter = new OleDbDataAdapter("select Category,Title,createtime from [data]", myConn);
        DataSet ds = new DataSet();
        //填充数据
        myAdapter.Fill(ds, "mytable");
        ps.DataSource = ds.Tables["mytable"].DefaultView;
        ps.AllowPaging = true;
        ps.PageSize = 3;
        ps.CurrentPageIndex = curpage - 1;

        this.lbtnFirstPage.Enabled = true;
        this.lbtnUpPage.Enabled = true;
        this.lbtnDownPage.Enabled = true;
        this.lbtnLastPage.Enabled = true;

        if (curpage == 1)//已经是第一页
        {
            this.lbtnFirstPage.Enabled = false;
            this.lbtnUpPage.Enabled = false;
        }
        if (curpage == ps.PageCount)//已经是末页
        {
            this.lbtnLastPage.Enabled = false;
            this.lbtnDownPage.Enabled = false;
        }

        this.lblTotalPage.Text = Convert.ToString(ps.PageCount);
        this.Repeater1.DataSource = ps;
        this.Repeater1.DataBind();
        myConn.Close();
    }

    protected void lbtnFirstPage_Click(object sender, EventArgs e)
    {
        this.lblCurPage.Text = Convert.ToString(1);
        this.dlBind();

    }

        protected void lbtnUpPage_Click(object sender, EventArgs e)
    {
        this.lblCurPage.Text = Convert.ToString(Convert.ToUInt32(this.lblCurPage.Text) - 1);
        this.dlBind();
    }

    protected void lbtnDownPage_Click(object sender, EventArgs e)
{
        this.lblCurPage.Text = Convert.ToString(Convert.ToUInt32(this.lblCurPage.Text) + 1);
        this.dlBind();

}
protected void lbtnLastPage_Click(object sender, EventArgs e)
{
this.lblCurPage.Text = this.lblTotalPage.Text;
this.dlBind();

}
}

数据库:

zhan198271

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Repeater控件分页

HTML代码:http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">http://www.w3.org/1999/xhtml" > 无标题页新闻分类标题更新时间
复制链接

扫一扫

专栏目录