Fork me on GitHub

AspNetPager 示例 - Repeater分页示例

该示例演示如何使用AspNetPager分页控件对Repeater控件进行分页。
订单编号订单日期公司名称客户编号雇员姓名
10981 1998/3/27 Hanari Carnes HANAR Nancy Davolio
10980 1998/3/27 Folk och fä HB FOLKO Margaret Peacock
10979 1998/3/26 Ernst Handel ERNSH Laura Callahan
10978 1998/3/26 Maison Dewey MAISD Anne Dodsworth
10977 1998/3/26 Folk och fä HB FOLKO Laura Callahan
10976 1998/3/25 HILARION-Abastos HILAA Nancy Davolio
10975 1998/3/25 Bottom-Dollar Markets BOTTM Nancy Davolio
10974 1998/3/25 Split Rail Beer & Ale SPLIR Janet Leverling
10973 1998/3/24 La corne d'abondance LACOR Michael Suyama
10972 1998/3/24 La corne d'abondance LACOR Margaret Peacock
10971 1998/3/24 France restauration FRANR Andrew Fuller
10970 1998/3/24 Bólido Comidas preparadas BOLID Anne Dodsworth

PagedRepeater.aspx:

<%@ Page Language="C#" AutoEventWireup="true"  MetaDescription="该示例演示如何使用AspNetPager分页控件对Repeater控件进行分页。" Inherits="PagedRepeater_Default" MasterPageFile="AspNetPager.master" Title="Repeater分页示例" Codebehind="PagedRepeater.aspx.cs" %>

<asp:Content runat="server" ContentPlaceHolderID="main">
        <asp:Repeater ID="Repeater1" runat="server">
        <HeaderTemplate>
        <table width="100%" class="table table-bordered table-striped table-hover">
        <tr><th style="width:15%">订单编号</th><th style="width:15%">订单日期</th><th style="width:30%">公司名称</th><th style="width:20%">客户编号</th><th style="width:20%">雇员姓名</th></tr>
        </HeaderTemplate>
        <ItemTemplate>
        <tr>
        <td><%#DataBinder.Eval(Container.DataItem,"orderid")%></td>
        <td><%#DataBinder.Eval(Container.DataItem,"orderdate","{0:d}")%></td>
        <td><%#DataBinder.Eval(Container.DataItem, "companyname")%></td>
        <td><%#DataBinder.Eval(Container.DataItem,"customerid")%></td>
        <td><%#DataBinder.Eval(Container.DataItem,"employeename")%></td>
        </tr>
        </ItemTemplate>
        <FooterTemplate>
        </table>
        </FooterTemplate>
        </asp:Repeater>
    
    <div class="pull-right">
        <webdiyer:AspNetPager ID="AspNetPager1" runat="server" Width="100%" UrlPaging="true" CssClass="pagination" LayoutType="Ul" PagingButtonLayoutType="UnorderedList" PagingButtonSpacing="0" CurrentPageButtonClass="active" PageSize="12" OnPageChanged="AspNetPager1_PageChanged">
        </webdiyer:AspNetPager></div>
</asp:Content>

PagedRepeater.aspx.cs:

using System;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;

public partial class PagedRepeater_Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            int totalOrders = (int)SqlHelper.ExecuteScalar(CommandType.StoredProcedure, "P_GetOrderNumber");
            AspNetPager1.RecordCount = totalOrders;
            //bindData(); //使用url分页,只需在分页事件处理程序中绑定数据即可,无需在Page_Load中绑定,否则会导致数据被绑定两次
        }
    }

    void bindData()
    {
        Repeater1.DataSource = SqlHelper.ExecuteReader(CommandType.StoredProcedure, ConfigurationManager.AppSettings["pagedSPName"],
            new SqlParameter("@startIndex", AspNetPager1.StartRecordIndex),
            new SqlParameter("@endIndex", AspNetPager1.EndRecordIndex));
        Repeater1.DataBind();
    }

    protected void AspNetPager1_PageChanged(object src, EventArgs e)
    {
        bindData();
    }
}