GridView配合AspNetPager 进行数据源分页的例子

最新推荐文章于 2019-09-09 14:09:44 发布

weixin_34143774

最新推荐文章于 2019-09-09 14:09:44 发布

阅读量133

点赞数

本文介绍如何使用AspNetPager分页控件实现网页数据分页显示。通过前后端代码结合，展示了具体配置方法及数据库交互过程。

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

很早就知道可以用陕西吴起娃做的 AspNetPager 进行分页

在以前做的很多项目中也用过效果不错不过都是别人写的代码我没有自己用过

今天做了一个例子体验一下:

前台页面:

添加引用: <%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

<webdiyer:AspNetPager ID="pagerNav" runat="server" AlwaysShow="True" ButtonImageNameExtension="n"
 CpiButtonImageNameExtension="r" CustomInfoText="" DisabledButtonImageNameExtension="g"
 Height="30" HorizontalAlign="right" ImagePath="../images" InputBoxStyle="border:1px #0000FF solid;text-align:center"
 NumericButtonTextFormatString="[{0}] " OnPageChanged="pagerNav_PageChanged" PageSize="3"
 PagingButtonSpacing="0" ShowBoxThreshold="10" ShowCustomInfoSection="left" SubmitButtonStyle="border:1px solid #000066;height:20px;width:40px"
 SubmitButtonText="GO" TextAfterInputBox="页" TextBeforeInputBox="转到第" Width="85%"
 NextPageText='' PrevPageText=''
 LastPageText='' FirstPageText=''>
 </webdiyer:AspNetPager>

 <asp:GridView EnableViewState="false" ID="GridView1" PageSize="3" runat="server" AllowPaging="True" AutoGenerateColumns="False">
 <Columns>
 <asp:BoundField DataField="sID" HeaderText="sID" SortExpression="sID" />
 <asp:BoundField DataField="sValue" HeaderText="sValue" SortExpression="sValue" />
 </Columns>
 <PagerSettings FirstPageText="首页" LastPageText="末页" NextPageText=">" PreviousPageText="<"
 PageButtonCount="3" Visible="False" />
 </asp:GridView>

后台代码:

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string sqlConnect = "Provider=SQLOLEDB;data source=HG-J3EJJ9LSW5PY;initial catalog =photomandb_dzrb;User ID=sa;password=hg;Connection Timeout=30";
            DataOperation.globalConnectionString = sqlConnect;
            DataSet ds = DataOperation.SelectDataBySql(@"

select sID,sValue,row from
(
select *,ROW_NUMBER() OVER (ORDER BY sID asc) AS Row from tInfoParameter ) as temp
where row >=1 and row <=3

");

GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();

            pagerNav.PageSize = 3;
            pagerNav.CurrentPageIndex = 1;
            pagerNav.RecordCount = 79;
        }

}

protected void pagerNav_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
{

pagerNav.CurrentPageIndex = e.NewPageIndex;

string Sql = @"

select sID,sValue,row from
(
select *,ROW_NUMBER() OVER (ORDER BY sID asc) AS Row from tInfoParameter ) as temp
where row >={0} and row <={1}

";
Sql = string.Format(Sql, e.NewPageIndex * 3 -2 , e.NewPageIndex * 3);
DataSet ds = DataOperation.SelectDataBySql(Sql);

GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();

}