ASP.NET分页实践-优快云博客

本文介绍了两种ASP.NET中实现分页的方法。一种是通过手动编写代码进行数据分页展示，另一种则是利用AspNetPager控件简化分页操作。两种方式均实现了数据集的分页加载，并展示了如何设置页面导航元素。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

早先分页的方式：

private DataSet Adapter(string cmdText, string tablename, params SqlParameter[] sqlparams) { SqlDataAdapter sdr = new SqlDataAdapter(cmdText, connectionString); if (sqlparams != null) sdr.SelectCommand.Parameters.AddRange(sqlparams); DataSet ds = new DataSet(); try { sdr.Fill(ds, tablename); return ds; } catch { return null; } finally { } } private bool PageBind(int CurrPage, string tablename, string id) { ViewState["CURRPAGE"] = CurrPage.ToString().Trim(); string ling = "0"; string cmdText = "select * from UserMicroBlog where UserName='" + Session["UserName"].ToString() + "' and toblog='" + ling + "' and tovideo='" + ling + "' order by BlogID desc "; PagedDataSource pagedDataSource = new PagedDataSource(); DataSet ds = Adapter(cmdText, tablename, null); if (ds == null) return false; pagedDataSource.DataSource = ds.Tables[tablename].DefaultView; pagedDataSource.AllowPaging = true; pagedDataSource.PageSize = 8; if (CurrPage > pagedDataSource.PageCount || CurrPage < 1) { return false; } pagedDataSource.CurrentPageIndex = CurrPage - 1; LabelCurrPage.Text = "第" + CurrPage.ToString() + "页"; LabelTotalPage.Text = "共" + pagedDataSource.PageCount.ToString() + "页"; ButtonPrePage.Enabled = true; ButtonNextPage.Enabled = true; if (CurrPage == 1) { ButtonPrePage.Enabled = false; } if (CurrPage == pagedDataSource.PageCount) { ButtonNextPage.Enabled = false; } //每一行的id（主键）绑定 DataList1.DataKeyField = id; //DataList1绑定数据源pageDataSource DataList1.DataSource = pagedDataSource; DataList1.DataBind(); return true; } protected void ButtonPrePage_Click(object sender, EventArgs e) { //显示前一页 if (ViewState["CURRPAGE"] == null) return; int CurrPage = Convert.ToInt32(ViewState["CURRPAGE"].ToString()); PageBind(CurrPage - 1, "UserMicroBlog", "BlogID"); } protected void ButtonNextPage_Click(object sender, EventArgs e) { //显示后一页 if (ViewState["CURRPAGE"] == null) return; int CurrPage = Convert.ToInt32(ViewState["CURRPAGE"].ToString()); PageBind(CurrPage + 1, "UserMicroBlog", "BlogID"); } 前台页面： <div class="fenye">  <asp:Button ID="ButtonPrePage" runat="server" Text="上一页" onclick="ButtonPrePage_Click" BorderStyle="None" CssClass="have" /> <asp:Label ID="LabelCurrPage" runat="server" Text="Label" CssClass="wu"></asp:Label> <asp:Label ID="LabelTotalPage" runat="server" Text="Label" CssClass="wu"></asp:Label>  <asp:Button ID="ButtonNextPage" runat="server" Text="下一页" onclick="ButtonNextPage_Click" BorderStyle="None" CssClass="have" /> </div> </div>

学习AspNetPager控件的分页方法：

using System; using System.Collections.Generic; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using BLL; using System.Data; public partial class _Default : System.Web.UI.Page { protected void BindData() { PagedDataSource pds = new PagedDataSource(); pds.AllowPaging = true; AspNetPager1.PageSize = 9; pds.PageSize = AspNetPager1.PageSize; pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1; DataView dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); pds.DataSource = dv; DataList1.DataSource = pds; DataList1.DataBind(); } protected void Page_Load(object sender, EventArgs e) { BindData(); } protected void AspNetPager1_PageChanged(object src, EventArgs e) { BindData(); } protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e) { AspNetPager1.RecordCount = e.AffectedRows; } }

default.aspx为：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %> <!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> <link href="App_Themes/baby/products.css" mce_href="App_Themes/baby/products.css" type="text/css" rel="Stylesheet" /> <link href="App_Themes/baby/product.css" mce_href="App_Themes/baby/product.css" type="text/css" rel="Stylesheet" /> <link type="image/x-icon" href="Common_Image/shared/logo.ico" mce_href="Common_Image/shared/logo.ico" rel="shortcut icon" /> </head> <body> <form id="form1" runat="server"> <div style="height: 757px; width: 900px; margin-left: auto; margin-right: auto;"> products are here:<br /> <mce:script type="text/javascript"></mce:script> <asp:DataList ID="DataList1" runat="server" DataKeyField="ProductId" Width="700px" RepeatColumns="3"> <ItemTemplate> <div class="products"> <p> <%#Eval("ProName") %></p> <div class="products_photo"> <a href="items.aspx?productId=<%#Eval(" mce_href="items.aspx?productId=<%#Eval("ProductId") %>"> <img src='Product_Image/<%#Eval("Photo") %>' alt='<%#Eval("ProName") %>' title='<%#Eval("ProName") %>' onload="javascript:limitImage(this);" /></a> </div> <div class="products_inf"> <table> <tbody> <tr class="products_inf_price"> <td> 原价: ￥<span class="products_yuanjia"> <asp:Label ID="OldMoneyLabel" runat="server" Text='<%# Eval("OldMoney") %>' /></span> </td> <td> 现价: ￥<span class="products_xianjia"> <asp:Label ID="NewMoneyLabel" runat="server" Text='<%# Eval("NewMoney") %>' /> </span> </td> </tr> <tr class="products_inf_price"> <td colspan="2"> 折扣: <asp:Label ID="DiscountLabel" runat="server" Text='<%# Eval("Discount") %>' /> </td> </tr> </tbody> </table> </div> <div style="display: none;" mce_style="display: none;"> <asp:Label ID="ProductIdLabel" runat="server" Text='<%# Eval("ProductId") %>' /> <asp:Label ID="CategoryIdLabel" runat="server" Text='<%# Eval("CategoryId") %>' /> </div> </div> </ItemTemplate> </asp:DataList> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:BabyConnectionString %>" DeleteCommand="DELETE FROM [Product] WHERE [ProductId] = @ProductId" InsertCommand="INSERT INTO [Product] ([CategoryId], [ProName], [HaveProduct], [NewMoney], [OldMoney], [Discount]) VALUES (@CategoryId, @ProName, @HaveProduct, @NewMoney, @OldMoney, @Discount)" SelectCommand="SELECT * FROM [Product] WHERE ([CategoryId] = @CategoryId)" UpdateCommand="UPDATE [Product] SET [CategoryId] = @CategoryId, [ProName] = @ProName, [HaveProduct] = @HaveProduct, [NewMoney] = @NewMoney, [OldMoney] = @OldMoney, [Discount] = @Discount WHERE [ProductId] = @ProductId" onselected="SqlDataSource1_Selected"> <DeleteParameters> <asp:Parameter Name="ProductId" Type="Int32" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="CategoryId" Type="Int32" /> <asp:Parameter Name="ProName" Type="String" /> <asp:Parameter Name="HaveProduct" Type="Boolean" /> <asp:Parameter Name="NewMoney" Type="Decimal" /> <asp:Parameter Name="OldMoney" Type="Decimal" /> <asp:Parameter Name="Discount" Type="String" /> </InsertParameters> <SelectParameters> <asp:QueryStringParameter Name="CategoryId" QueryStringField="category" Type="Int32" /> </SelectParameters> <UpdateParameters> <asp:Parameter Name="CategoryId" Type="Int32" /> <asp:Parameter Name="ProName" Type="String" /> <asp:Parameter Name="HaveProduct" Type="Boolean" /> <asp:Parameter Name="NewMoney" Type="Decimal" /> <asp:Parameter Name="OldMoney" Type="Decimal" /> <asp:Parameter Name="Discount" Type="String" /> <asp:Parameter Name="ProductId" Type="Int32" /> </UpdateParameters> </asp:SqlDataSource> <webdiyer:AspNetPager ID="AspNetPager1" runat="server" HorizontalAlign="Center" OnPageChanged="AspNetPager1_PageChanged" Width="100%" CustomInfoHTML="第%CurrentPageIndex%页，共%PageCount%页，每页%PageSize%条" FirstPageText="首页" LastPageText="尾页" NextPageText="下一页" PageIndexBoxType="DropDownList" PrevPageText="上一页" ShowCustomInfoSection="Left" ShowMoreButtons="False" ShowPageIndexBox="Always" SubmitButtonText="Go" TextAfterPageIndexBox="页" TextBeforePageIndexBox="转到"> </webdiyer:AspNetPager> </div> </form> </body> </html>

下载了aspnetpager的实例：