很早就知道 可以用 陕西吴起娃 做的 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='<font face="webdings"></font>' PrevPageText='<font face="webdings"></font>'

                LastPageText='<font face="webdings"></font>' FirstPageText='<font face="webdings"></font>'>

            </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="&gt;" PreviousPageText="&lt;"

                    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();

    }