Fork me on GitHub

AspNetPager 示例 - 格式化导航按钮

该示例演示如何使用自定义AspNetPager分页控件的分页导航按钮文本及样式。
订单编号:11077     订单日期:1998/5/6
公司名称:Rattlesnake Canyon Grocery
雇员姓名:Nancy Davolio

订单编号:11076     订单日期:1998/5/6
公司名称:Bon app'
雇员姓名:Margaret Peacock

订单编号:11075     订单日期:1998/5/6
公司名称:Richter Supermarkt
雇员姓名:Laura Callahan

订单编号:11074     订单日期:1998/5/6
公司名称:Simons bistro
雇员姓名:Robert King

订单编号:11073     订单日期:1998/5/5
公司名称:Pericles Comidas clásicas
雇员姓名:Andrew Fuller

订单编号:11072     订单日期:1998/5/5
公司名称:Ernst Handel
雇员姓名:Margaret Peacock

订单编号:11071     订单日期:1998/5/5
公司名称:LILA-Supermercado
雇员姓名:Nancy Davolio

订单编号:11070     订单日期:1998/5/5
公司名称:Lehmanns Marktstand
雇员姓名:Andrew Fuller

订单编号:11069     订单日期:1998/5/4
公司名称:Tortuga Restaurante
雇员姓名:Nancy Davolio

订单编号:11068     订单日期:1998/5/4
公司名称:Queen Cozinha
雇员姓名:Laura Callahan

ButtonsFormat.aspx:

<%@ Page Language="C#" MasterPageFile="AspNetPager.master" MetaDescription="该示例演示如何使用自定义AspNetPager分页控件的分页导航按钮文本及样式。" AutoEventWireup="true" Inherits="ButtonsFormat_Default" Title="格式化导航按钮" Codebehind="ButtonsFormat.aspx.cs" %>
<asp:Content ID="Content1" ContentPlaceHolderID="main" Runat="Server">
        <asp:DataList ID="DataList1" runat="server"  RepeatDirection="Horizontal" RepeatColumns="2" Width="100%">
        <ItemStyle Width="50%"/>
<ItemTemplate>
订单编号:<%#DataBinder.Eval(Container.DataItem,"orderid")%>&nbsp;&nbsp;&nbsp;&nbsp;
订单日期:<font color="blue"><%#DataBinder.Eval(Container.DataItem,"orderdate","{0:d}")%></font><br>
公司名称:<%#DataBinder.Eval(Container.DataItem,"companyname")%><br>
雇员姓名:<%#DataBinder.Eval(Container.DataItem,"employeename")%><br>
<hr>
</ItemTemplate>
        </asp:DataList>
    <webdiyer:aspnetpager id="AspNetPager1" runat="server" horizontalalign="Center" PagingButtonSpacing="0" NumericButtonCount="8" onpagechanged="AspNetPager1_PageChanged"
        width="100%"  PageIndexBoxStyle="width:19px" FirstPageText="【首页】" LastPageText="【尾页】" NextPageText="【后页】" PrevPageText="【前页】" NumericButtonTextFormatString="【{0}】"
        TextAfterPageIndexBox="页" TextBeforePageIndexBox="转到第"  CustomInfoHTML="Page  <font color='red'><b>%CurrentPageIndex%</b></font> of  %PageCount%&nbsp;&nbsp;Order %StartRecordIndex%-%EndRecordIndex%"></webdiyer:aspnetpager>
</asp:Content>

ButtonsFormat.aspx.cs:

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI;

public partial class ButtonsFormat_Default : Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            int totalOrders = (int)SqlHelper.ExecuteScalar(CommandType.StoredProcedure, "P_GetOrderNumber");
            AspNetPager1.RecordCount = totalOrders;
            bindData();
        }
    }

    void bindData()
    {
        DataList1.DataSource = SqlHelper.ExecuteReader(CommandType.StoredProcedure, ConfigurationManager.AppSettings["pagedSPName"],
            new SqlParameter("@startIndex", AspNetPager1.StartRecordIndex),
            new SqlParameter("@endIndex", AspNetPager1.EndRecordIndex));
        DataList1.DataBind();
    }
    protected void AspNetPager1_PageChanged(object src, EventArgs e)
    {
        bindData();
    }
}