Repeater分页显示

最新推荐文章于 2024-11-03 09:30:00 发布

www_sw

最新推荐文章于 2024-11-03 09:30:00 发布

阅读量401

点赞数

分类专栏： asp.net 文章标签： dataset object 数据库 server 服务器 asp

本文链接：https://blog.csdn.net/www_sw/article/details/4182058

版权

asp.net 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

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 DataRepeater : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { this.Label2.Text = "1"; this .DataBindToRepeater (Rpt); } } public void DataBindToRepeater( Repeater Rpt) { int curPage = Convert.ToInt32(this.Label2.Text); SqlConnection con = DB.createConnection(); con.Open(); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = new SqlCommand("select * from province", con); DataSet ds = new DataSet(); sda.Fill(ds, "province"); System.Web.UI.WebControls.PagedDataSource ps= new PagedDataSource(); ps.DataSource = ds.Tables["province"].DefaultView; ps.AllowPaging = true; ps.PageSize = 3; ps.CurrentPageIndex = curPage - 1; this.btnNext.Enabled = true; this.btnPre.Enabled = true; if (ps.CurrentPageIndex == 0) { this.btnPre.Enabled = false; } if (ps.CurrentPageIndex == ps.PageCount-1) { this.btnNext.Enabled = false; } this.Rpt.DataSource = ps; this.Rpt.DataBind(); } protected void btnPre_Click(object sender, EventArgs e) { this.Label2.Text = Convert.ToString(Convert.ToInt32(this.Label2.Text) - 1); this.DataBindToRepeater(Rpt);//web页是无状态的每次发送的服务器都需要重新绑定数据库 } protected void btnNext_Click(object sender, EventArgs e) { this.Label2.Text = Convert.ToString(Convert.ToInt32(this.Label2.Text) + 1); this.DataBindToRepeater(Rpt ); } }

<asp:Repeater ID="Rpt" runat="server">
        <HeaderTemplate ><h1 >页眉</h1>

        </HeaderTemplate>
           <ItemTemplate >
         编号：<%# DataBinder .Eval (Container .DataItem ,"proID") %>
         省份：<%# DataBinder .Eval (Container .DataItem ,"proName") %>
         <br />
        </ItemTemplate>

        <AlternatingItemTemplate >        <%--交错项 --%>
        <font color="red" >
         编号：<%# DataBinder .Eval (Container .DataItem ,"proID") %>
         省份：<%# DataBinder .Eval (Container .DataItem ,"proName") %>
         <br /></font>
         </AlternatingItemTemplate>
        <SeparatorTemplate ><hr />     <%--分割项--%>
        </SeparatorTemplate>
        <FooterTemplate >         <%--页脚--%>
        <h1 >页脚</h1>
        </FooterTemplate>
        </asp:Repeater>