Repeater 自定义分页

来源：互联网发布：周立功嵌入式linux 编辑：程序博客网时间：2024/05/16 07:02
HTML代码： <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <div style="text-align: center">
            <table border="0" cellpadding="0" cellspacing="0" style="z-index: 100; left: 115px;
                width: 726px; position: absolute; top: 23px; height: 122px">
                <tr>
                    <td style="width: 118px; height: 3px">
                             
                        <asp:Repeater ID="Repeater1" runat="server">
                        <ItemTemplate>
                        <table width=400px height=100px>
                          <tr>
                          <td>员工编号:<%#DataBinder.Eval(Container.DataItem,"job_id")%></td>
                          <td>员工描述:<%#Eval("job_desc")%></td>
                          </tr>
                        </table>
                        </ItemTemplate>
                        <HeaderTemplate><h3>员工信息</h3></HeaderTemplate>
                        <FooterTemplate><h3>员工列表</h3></FooterTemplate>
                        <SeparatorTemplate>
                        <hr color="red" />
                        </SeparatorTemplate>
                        <AlternatingItemTemplate>
                        <table width=400px height=100px>
                          <tr>
                          <td><font color='red'>员工编号:<%#DataBinder.Eval(Container.DataItem,"job_id")%></font></td>
                          <td><font color='red'>员工描述:<%#Eval("job_desc")%></font></td>
                          </tr>
                        </table>
                        </AlternatingItemTemplate>
                        </asp:Repeater>
                    </td>
                </tr>
                <tr>
                    <td style="width: 118px; height: 19px;">
                        <asp:Label ID="Label1" runat="server" Text="总页码:"></asp:Label>
                        <asp:Label ID="lblCount" runat="server"></asp:Label>
                                     <asp:Label ID="Label3" runat="server"
                            Text="当前页码:"></asp:Label>
                        <asp:Label ID="lblCurrentPage" runat="server"></asp:Label>
                                         <asp:LinkButton ID="lnkPrev"
                            runat="server" OnClick="lnkPrev_Click">上一页</asp:LinkButton>
                                        
                        <asp:LinkButton ID="lnkNext" runat="server" OnClick="lnkNext_Click">下一页</asp:LinkButton></td>
                </tr>
            </table>
        </div>
    
    </div>
    </form>
</body>
</html>
后台代码：
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
public partial class Default3 : System.Web.UI.Page
{
    /// <summary> 
    /// Post方式分页 
    /// </summary> 
    /// <param name="sender"></param> 
    /// <param name="e"></param> 
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            this.lblCurrentPage.Text = "1";
            this.DataBindToRepeater();
        }
    }
    public void DataBindToRepeater()
    {
        SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=;database=pubs");
        conn.Open();
        SqlCommand cmd = new SqlCommand("select * from jobs", conn);
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = cmd;
        DataSet ds = new DataSet();
        sda.Fill(ds, "jobs");
        //设置分页数据源,实际上它是DataGird控件的封装类 
        PagedDataSource pds = new PagedDataSource();
        pds.DataSource = ds.Tables["jobs"].DefaultView;
        //允许分页 
        pds.AllowPaging = true;
        //每页显示记录条数 
        pds.PageSize = 3;
        //当前页码数 
        int curPage = Convert.ToInt32(this.lblCurrentPage.Text);
        //索引号分页 
        pds.CurrentPageIndex = curPage - 1;
        //总页码数 
        this.lblCount.Text = Convert.ToString(pds.PageCount);
        //显示分页控件的状态 
        this.lnkPrev.Enabled = true;
        this.lnkNext.Enabled = true;
        //判断是第一页 
        if (pds.IsFirstPage)
        {
            this.lnkPrev.Enabled = false;
        }
        //判断是最后页 
        if (pds.IsLastPage)
        {
            this.lnkNext.Enabled = false;
        }
        this.Repeater1.DataSource = pds;
        this.Repeater1.DataBind();
    }
    protected void lnkPrev_Click(object sender, EventArgs e)
    {
        this.lblCurrentPage.Text = Convert.ToString(Convert.ToInt32(this.lblCurrentPage.Text) - 1);
        DataBindToRepeater();
    }
    protected void lnkNext_Click(object sender, EventArgs e)
    {
        this.lblCurrentPage.Text = Convert.ToString(Convert.ToInt32(this.lblCurrentPage.Text) + 1);
        DataBindToRepeater();
    }
}