.NET实现Repeater控件+AspNetPager控件分页

最新推荐文章于 2018-04-27 16:47:39 发布

转载最新推荐文章于 2018-04-27 16:47:39 发布 · 768 阅读

.net 专栏收录该内容

1 篇文章

订阅专栏

本文介绍如何使用AspNetPager控件实现Web页面的数据分页显示。从添加控件引用到前台页面展示，再到后台代码逻辑处理，最后到CSS样式定制，详细步骤一应俱全。

1.加入引用

将AspNetPager控件引入到项目中,即在aspx页面里添加引用，把AspNetPager的dll文件放到到Bin文件夹目录下

然后在工具箱--》常规--》右键--》选择项。。--》找到这个AspNetPager
using System.Data.SqlClient;
using Wuqi.Webdiyer;

2.前台显示页面aspx

AspNetPager的控件必须放在form runat="server"之内方可运行！！！

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

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

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

3.后台代码部分aspx.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.SqlClient;
using Wuqi.Webdiyer;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bindsql();
        }
    }
    private void bindsql()
    {
        SqlConnection con = new SqlConnection("Data Source=20090731-5465;Initial Catalog=Northwind;Integrated Security=True");
        con.Open();
        SqlDataAdapter sqlda = new SqlDataAdapter("select * from customers", con);
        DataSet ds = new DataSet();
        sqlda.Fill(ds);
        PagedDataSource pdsList = new PagedDataSource();
        pdsList.DataSource = ds.Tables[0].DefaultView;
        pdsList.AllowPaging = true;//数据源允许分页
        pdsList.PageSize = this.AspNetPager1.PageSize;//取控件的分页大小
        pdsList.CurrentPageIndex = this.AspNetPager1.CurrentPageIndex - 1;//显示当前页
        //设置控件
        this.AspNetPager1.RecordCount = ds.Tables[0].Rows.Count;//记录总数
        this.AspNetPager1.PageSize = 10;
        this.Repeater1.DataSource = pdsList;
        this.Repeater1.DataBind();

    }
    protected void AspNetPager1_PageChanging(object src, PageChangingEventArgs e)
    {
        AspNetPager1.CurrentPageIndex = e.NewPageIndex;
        bindsql();
    }
}

4.CSS文件样式表

body {
}
.pages { color: #999; }
.pages a, .pages .cpb { text-decoration:none;float: left; padding: 0 5px; border: 1px solid #ddd;background: #ffff;margin:0 2px; font-size:11px; color:#000;}
.pages a:hover { background-color: #E61636; color:#fff;border:1px solid #E61636; text-decoration:none;}
.pages .cpb { font-weight: bold; color: #fff; background: #E61636; border:1px solid #E61636;}