Repeater利用PagedDataSource进行分页
用PagedDataSource類實(shí)現(xiàn)Repeater和DataList的分頁。 PagedDataSource封裝了DataGrid的分頁屬性，我們可以象DataGrid那樣進(jìn)行分頁。
HTML代碼
<%@ Page Language="C#" AutoEventWireup="true"? CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!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>無標(biāo)題頁</title>
</head>
<body style="text-align:center">
??? <form id="form1" runat="server">
??? <div align="center" style="width:800px;">
??????? <table cellpadding="0" cellspacing="1" border="0" bgcolor="#000000" width="100%">
??????????? <tr>
??????????????? <td bgcolor=#ffffff>au_id</td>
??????????????? <td bgcolor=#ffffff>au_fname</td>
??????????????? <td bgcolor=#ffffff>au_lname</td>
??????????????? <td bgcolor=#ffffff>phone</td>
??????????????? <td bgcolor=#ffffff>address</td>
??????????????? <td bgcolor=#ffffff>city</td>
??????????????? <td bgcolor=#ffffff>state</td>
??????????????? <td bgcolor=#ffffff>zip</td>
???????????????? <td bgcolor=#ffffff>contract</td>
??????????? </tr>
??????? <asp:Repeater runat="server" ID="Rpt_Test" OnItemDataBound="Rpt_Test_ItemDataBound">
??????????? <ItemTemplate>
??????????????????? <tr>
??????????????????????? <td bgcolor=#ffffff>
??????????????????????????? <%#DataBinder.Eval(Container,"DataItem.au_id") %>
??????????????????????? </td >
??????????????????????? <td bgcolor=#ffffff>
??????????????????????????? <%#DataBinder.Eval(Container,"DataItem.au_fname") %>
??????????????????????? </td>
??????????????????????? <td bgcolor=#ffffff>
??????????????????????????? <%#DataBinder.Eval(Container,"DataItem.au_lname") %>
??????????????????????? </td>
??????????????????????? <td bgcolor=#ffffff>
??????????????????????????? <%#DataBinder.Eval(Container,"DataItem.phone") %>
??????????????????????? </td>
??????????????????????? <td bgcolor=#ffffff>
??????????????????????????? <%#DataBinder.Eval(Container,"DataItem.address") %>
??????????????????????? </td>
??????????????????????? <td bgcolor=#ffffff>
??????????????????????????? <%#DataBinder.Eval(Container,"DataItem.city") %>
??????????????????????? </td>
??????????????????????? <td bgcolor=#ffffff>
??????????????????????????? <%#DataBinder.Eval(Container,"DataItem.state") %>
??????????????????????? </td>
??????????????????????? <td bgcolor=#ffffff>
??????????????????????????? <%#DataBinder.Eval(Container,"DataItem.zip") %>
??????????????????????? </td>
??????????????????????? <td bgcolor=#ffffff>
??????????????????????????? <%#DataBinder.Eval(Container,"DataItem.contract") %>
??????????????????????? </td>
??????????????????? </tr>
??????????? </ItemTemplate>
??????? </asp:Repeater>???
??????? </table>
??? </div>
??????? <asp:Label ID="lblCurrentPage" runat="server" Text="Label" Font-Size=12px></asp:Label>
??????? <asp:HyperLink ID="lnkPrev" runat="server" Font-Size=12px>上一頁</asp:HyperLink>
??????? <asp:HyperLink ID="lnkNext" runat="server" Font-Size=12px>下一頁</asp:HyperLink>
??? </form>
</body>
</html>
代碼頁面?
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;
public partial class _Default : System.Web.UI.Page
{
??? #region Page_Load()
??? protected void Page_Load(object sender, EventArgs e)
??? {
??????? PagedDataSource objds = new PagedDataSource();
??????? objds.DataSource = ReturnDataTable().DefaultView;
??????? objds.AllowPaging = true;
??????? objds.PageSize = 5;
??????? int CurPage;
??????? if (Request.QueryString["Page"] != null)
??????? {
??????????? CurPage = Convert.ToInt32(Request.QueryString["Page"]);
??????? }
??????? else
??????? {
??????????? CurPage = 1;
??????? }
??????? objds.CurrentPageIndex = CurPage - 1;
??????? lblCurrentPage.Text = "當(dāng)前頁:" + CurPage.ToString();
??????? if (!objds.IsFirstPage)
??????? {
??????????? lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);
??????? }
??????? if (!objds.IsLastPage)
??????? {
??????????? lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);
??????? }
??????? Rpt_Test.DataSource = objds;
??????? Rpt_Test.DataBind();
??? }
??? #endregion
??? #region 返回?cái)?shù)據(jù)表中數(shù)據(jù)
??? /// <summary>
??? /// 返回?cái)?shù)據(jù)表中數(shù)據(jù)
??? /// </summary>
??? /// <returns></returns>
??? private DataTable ReturnDataTable()
??? {
??????? DataSet ds = new DataSet();
??????? using (SqlConnection cn = new SqlConnection("server=jhtest4;uid=sa;pwd=123;database=pubs"))
??????? {
??????????? SqlCommand cmd = new SqlCommand();
??????????? cmd.Connection = cn;
??????????? cmd.CommandText = "select * from authors";
???????????
??????????? SqlDataAdapter da = new SqlDataAdapter(cmd);
??????????? try
??????????? {
??????????????? da.Fill(ds);
??????????? }
??????????? catch (Exception ex)
??????????? {
??????????????? throw ex;
??????????? }
??????? }
??????? return ds.Tables[0];
??? }
??? #endregion
??? #region Rpt_Test_ItemDataBound
??? /// <summary>
??? /// Rpt_Test_ItemDataBound
??? /// </summary>
??? /// <param name="sender"></param>
??? /// <param name="e"></param>
??? protected void Rpt_Test_ItemDataBound(object sender, RepeaterItemEventArgs e)
??? {
??? }
??? #endregion
}
轉(zhuǎn)載于:https://www.cnblogs.com/VirtualMJ/archive/2006/09/26/515380.html
總結(jié)
以上是生活随笔為你收集整理的Repeater利用PagedDataSource进行分页的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： AJAX中的Back Button/Bo
- 下一篇： 浑浑噩噩得长假