Repeater分页-白红宇

Repeater分页

阅读量：4931 次

发布时间：2019-06-11

本文共 6364 字，大约阅读时间需要 21 分钟。

第一种方式：

数据库连接代码：

                        01             using System;            
          
                        02             using System.Data;            
          
                        03             using System.Configuration;            
          
                        04             using System.Web;            
          
                        05             using System.Web.Security;            
          
                        06             using System.Web.UI;            
          
                        07             using System.Web.UI.WebControls;            
          
                        08             using System.Web.UI.WebControls.WebParts;            
          
                        09             using System.Web.UI.HtmlControls;            
          
                        10             using System.Data.SqlClient;            
          
                        11             using System.Data.Sql;            
          
                        12                          
          
                        13                          
          
                        14                          
          
                        15             public partial class _Default : System.Web.UI.Page            
          
                        16             { 
            
                        17              private void con()            
          
                        18              { 
            
                        19              string connstring = ConfigurationManager.ConnectionStrings["AdventureWorksDWConnectionString"].ConnectionString;            
          
                        20              SqlConnection con = new SqlConnection(connstring);            
          
                        21              SqlConnection conn = new SqlConnection();            
          
                        22              DataSet ds = new DataSet();            
          
                        23              SqlDataAdapter sda = new SqlDataAdapter("select * from FactSalesQuota", con);            
          
                        24              sda.Fill(ds, "name");            
          
                        25              SqlDataAdapter sda2 = new SqlDataAdapter("select * from ProspectiveBuyer", con);            
          
                        26              sda2.Fill(ds, "title");            
          
                        27              PagedDataSource pds = new PagedDataSource();            
          
                        28              pds.DataSource = ds.Tables["name"].DefaultView;            
          
                        29              //PagedDataSource aa = new PagedDataSource();            
          
                        30              pds.AllowPaging = true;//允许分页            
          
                        31              pds.PageSize = 8;//单页显示项数            
          
                        32              int CurPage;            
          
                        33              if (Request.QueryString["Page"] != null)            
          
                        34              CurPage = Convert.ToInt32(Request.QueryString["Page"]);            
          
                        35              else            
          
                        36              CurPage = 1;            
          
                        37              pds.CurrentPageIndex = CurPage - 1;            
          
                        38              int Count = pds.PageCount;            
          
                        39                          
          
                        40              lblCurrentPage.Text = "当前页：" + CurPage.ToString();            
          
                        41              labPage.Text = Count.ToString();            
          
                        42                          
          
                        43              if (!pds.IsFirstPage)            
          
                        44              { 
            
                        45              this.first.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1";            
          
                        46              this.last.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(Count - 1); ;            
          
                        47              up.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);            
          
                        48              }            
          
                        49              else            
          
                        50              { 
            
                        51              this.first.Visible = false ;            
          
                        52              this.last.Visible = false ;            
          
                        53                          
          
                        54              }            
          
                        55                          
          
                        56              if (!pds.IsLastPage)            
          
                        57              { 
            
                        58                          
          
                        59                          
          
                        60              next.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);            
          
                        61              }            
          
                        62              else            
          
                        63              { 
            
                        64              this.first.Visible = false;            
          
                        65              this.last.Visible = false;            
          
                        66                          
          
                        67              }            
          
                        68                          
          
                        69              Repeater1.DataSource = pds ;            
          
                        70              Repeater1.DataBind();            
          
                        71                          
          
                        72              }            
          
                        73                          
          
                        74                          
          
                        75                          
          
                        76              protected void Page_Load(object sender, EventArgs e)            
          
                        77              { 
            
                        78              if (!IsPostBack)            
          
                        79              { 
            
                        80              con();            
          
                        81              this.first.Visible = true;            
          
                        82              this.last.Visible = true;            
          
                        83              //this.Repeater1.DataSource = pds();            
          
                        84              //this.Repeater1.DataBind();            
          
                        85                          
          
                        86              }            
          
                        87                          
          
                        88              }            
          
                        89             }

aspx文件代码：

                        01             <table>            
          
                        02              <tr ><td class="style1" align ="left" >hehe</td></tr>            
          
                        03                          
          
                        04              <tr ><td class="style1">             
          
                        05              <asp:Repeater ID="Repeater1" runat="server" >            
          
                        06                          
          
                        07              <HeaderTemplate ><table><tr><td>头模板</td></tr></HeaderTemplate>            
          
                        08              <ItemTemplate ><tr><td ><font color="red" > <%#Eval("timekey")%></font></td></tr></ItemTemplate>            
          
                        09              <AlternatingItemTemplate ><tr><td > <a href ='Default.aspx?id=<%#"databaselogid" %>'><%#Eval("SalesAmountQuota")%></a></td></tr></AlternatingItemTemplate>            
          
                        10              <FooterTemplate ><tr><td>尾模板</td></tr></table></FooterTemplate>            
          
                        11              </asp:Repeater>             
          
                        12              </td> </tr>             
          
                        13                          
          
                        14                          
          
                        15              <tr> <td class="style1">            
          
                        16              <asp:HyperLink ID="first" runat="server">首页</asp:HyperLink>            
          
                        17              <asp:HyperLink ID="next" runat="server">下一页</asp:HyperLink>            
          
                        18              <asp:HyperLink ID="up" runat="server">上一页</asp:HyperLink>            
          
                        19              <asp:HyperLink ID="last" runat="server">末页</asp:HyperLink>            
          
                        20              </td></tr>            
          
                        21                          
          
                        22              <tr><td class="style1">当前页为：<asp:Label ID="lblCurrentPage" runat="server"            
          
                        23              Text="Label"></asp:Label>            
          
                        24              <br />            
          
                        25              共<asp:Label ID="labPage" runat="server" Text="Label"></asp:Label>            
          
                        26              页</td></tr>            
          
                        27                          
          
                        28             </table>

第二种方式：

                        01             using System;            
          
                        02             using System.Collections;            
          
                        03             using System.Configuration;            
          
                        04             using System.Data;            
          
                        05             using System.Linq;            
          
                        06             using System.Web;            
          
                        07             using System.Web.Security;            
          
                        08             using System.Web.UI;            
          
                        09             using System.Web.UI.HtmlControls;            
          
                        10             using System.Web.UI.WebControls;            
          
                        11             using System.Web.UI.WebControls.WebParts;            
          
                        12             using System.Xml.Linq;            
          
                        13             using System.Data.SqlClient;            
          
                        14                          
          
                        15             public partial class databind : System.Web.UI.Page            
          
                        16             { 
            
                        17                          
          
                        18              protected void Page_Load(object sender, EventArgs e)            
          
                        19              { 
            
                        20              if (!IsPostBack)            
          
                        21              { 
            
                        22              num.Text = "1";            
          
                        23              repdatabind();             
          
                        24              }            
          
                        25                          
          
                        26                          
          
                        27              }            
          
                        28              public void repdatabind()            
          
                        29              { 
            
                        30              string connstring = ConfigurationManager.ConnectionStrings["AdventureWorksDWConnectionString"].ConnectionString;            
          
                        31              SqlConnection con = new SqlConnection(connstring);            
          
                        32              SqlConnection conn = new SqlConnection();            
          
                        33              DataSet ds = new DataSet();            
          
                        34              SqlDataAdapter sda = new SqlDataAdapter("select * from DimProduct", con);            
          
                        35              sda.Fill(ds, "name");            
          
                        36              PagedDataSource pds = new PagedDataSource();            
          
                        37              pds.DataSource = ds.Tables["name"].DefaultView;            
          
                        38              pds.AllowPaging = true;//允许分页            
          
                        39              pds.PageSize = 8;//单页显示项数            
          
                        40                          
          
                        41              int curpage = Convert.ToInt32(num.Text);            
          
                        42              this.BtnDown.Enabled = true;            
          
                        43              this.BtnUp.Enabled = true;            
          
                        44              pds.CurrentPageIndex = curpage - 1;            
          
                        45              if (curpage == 1)            
          
                        46              { 
            
                        47              this.BtnUp.Enabled = false;            
          
                        48              }            
          
                        49              if (curpage == pds.PageCount)            
          
                        50              { 
            
                        51              this.BtnDown.Enabled = false;            
          
                        52              }            
          
                        53              this.Repeater1.DataSource = pds;            
          
                        54              this.Repeater1.DataBind();            
          
                        55              }            
          
                        56                          
          
                        57              protected void BtnUp_Click(object sender, EventArgs e)            
          
                        58              { 
            
                        59              this.num.Text =Convert.ToString ( Convert.ToInt32(num.Text)- 1) ;            
          
                        60              repdatabind();            
          
                        61              }            
          
                        62              protected void BtnDown_Click(object sender, EventArgs e)            
          
                        63              { 
            
                        64              this.num.Text = Convert.ToString(Convert.ToInt32(num.Text)+ 1) ;            
          
                        65              repdatabind();            
          
                        66              }            
          
                        67             }

aspx代码：

                        01             <%@ Page Language="C#" AutoEventWireup="true" CodeFile="databind.aspx.cs" Inherits="databind" %>            
          
                        02                          
          
                        03             <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">            
          
                        04                          
          
                        05             <html xmlns="">            
          
                        06             <head runat="server">            
          
                        07              <title>无标题页</title>            
          
                        08             </head>            
          
                        09             <body>            
          
                        10              <form id="form1" runat="server">            
          
                        11              <div>            
          
                        12                          
          
                        13              <asp:Panel ID="Panel1" runat="server" Height="173px">            
          
                        14               <asp:Repeater ID="Repeater1" runat="server"><HeaderTemplate ><table border onmousedown="1" ><tr><td >头模板</td></tr></HeaderTemplate><ItemTemplate ><tr><td>序号：<%# Eval("ProductKey") %></td></tr><tr><td>编码：<%# Eval("ProductAlternateKey") %></td></tr></ItemTemplate><FooterTemplate ><tr><td>脚模板</td></tr></table>< /FooterTemplate>            
          
                        15              </asp:Repeater>            
          
                        16              当前页：<asp:Label ID="num" runat="server"></asp:Label>            
          
                        17              <br />            
          
                        18              <asp:Button ID="BtnUp" runat="server" onclick="BtnUp_Click" Text="上一页" />            
          
                        19              <asp:Button ID="BtnDown" runat="server" onclick="BtnDown_Click" Text="下一页" />            
          
                        20              </asp:Panel>            
          
                        21              <br />            
          
                        22              <br />            
          
                        23                          
          
                        24              </div>            
          
                        25              </form>            
          
                        26             </body>            
          
                        27             </html>