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();
- }
- }