Repeart分页(其实DataList也可采用这个,只是改一下控件名而已)

最新推荐文章于 2025-10-21 22:09:11 发布

原创最新推荐文章于 2025-10-21 22:09:11 发布 · 433 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#dataset #object #database #server #dell

本文展示了一个使用ASP.NET实现数据库分页显示的例子。通过连接SQL Server数据库并利用PagedDataSource进行分页处理，实现了产品数据的有效管理和展示。文中详细介绍了按钮点击事件触发的页面切换逻辑。

    private void bandPage()
    {
        SqlConnection con = new SqlConnection("server=dell099;database=Study_NET;uid=sa;pwd=sasa");
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter("select * from product", con);
        DataSet ds = new DataSet();
        sda.Fill(ds, "temptable");
        PagedDataSource pds = new PagedDataSource();
        pds.DataSource = ds.Tables["temptable"].DefaultView;
        pds.AllowPaging = true;
        pds.PageSize = 5;
        pds.CurrentPageIndex = Convert.ToInt32(this.labPage.Text) - 1; //控件名labPage.text为当前页数
        Repeater1.DataSource = pds;
        this.laball.Text = pds.PageCount.ToString();     //label1.text为总页数
        labPage.Text = (pds.CurrentPageIndex + 1).ToString();
        this.btnfirst.Enabled = true;
        this.btnlast.Enabled = true;
        this.btnnext.Enabled = true;
        this.btnpre.Enabled = true;
        if (pds.CurrentPageIndex < 1)
        {
            this.btnpre.Enabled = false;
            this.btnfirst.Enabled = false;
        }
        if (pds.CurrentPageIndex == pds.PageCount - 1)
        {
            this.btnnext.Enabled = false;
            this.btnlast.Enabled = false;
        }
        Repeater1.DataBind();
        con.Close();

}

    protected void btnfirst_Click(object sender, EventArgs e)
    {
        labPage.Text = "1";
        bandPage();
    }
    protected void btnpre_Click(object sender, EventArgs e)
    {
        labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) - 1);
        bandPage();
    }
    protected void btnnext_Click(object sender, EventArgs e)
    {
        labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) +1);
        bandPage();
    }
    protected void btnlast_Click(object sender, EventArgs e)
    {
        labPage.Text = this.laball.Text;
        bandPage();
    }