AspNetPager+SqlHelper+GridView分页

前台代码：

C#代码

<div>  
    新闻列表：<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">  
        <Columns>  
            <asp:BoundField DataField="id" HeaderText="ID" />  
            <asp:BoundField DataField="title" HeaderText="Title" />  
            <asp:BoundField DataField="submitTime" HeaderText="time" />  
        </Columns>  
    </asp:GridView>  
      <br />  
     <br />  
   <Webdiyer:AspNetPager id="AspNetPager1"  
       runat="server"  
       PageSize="8"  
       NumericButtonCount="8"  
       ShowCustomInfoSection="left"  
       PagingButtonSpacing="0"  
       ShowInputBox="always"  
       CssClass="mypager"  
       HorizontalAlign="right"  
       SubmitButtonText="转到"  
       NumericButtonTextFormatString="[{0}]" OnPageChanged="AspNetPager1_PageChanged"/>  
    <br />  
    </div>

后台CS：

C#代码

protected void Page_Load(object sender, EventArgs e)  
{  
    this.AspNetPager1.RecordCount = this.GetCount();//总记录数  
    if (!Page.IsPostBack)  
    {  
        GridViewBind();  
    }  
}  
//计算记录总数  
public int GetCount()  
{  
    int count = 0;  
    string sql = "select count(*) as count from info";  
    SqlDataReader dr=DataBase.DataBase.ExcuteReader(sql);  
    if (dr.Read())  
    {  
        count = int.Parse(dr["count"].ToString());  
    }  
    return count;  
}  
//加载数据  
public void GridViewBind()  
{  
    int Pager1 = AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1);  
    int Pager2 = AspNetPager1.PageSize;  
    String sql = "select top " + Pager2 + " * from info where id not in (select top " + Pager1 + " id from info order by id desc) order by id desc";  
    DataSet ds = DataBase.DataBase.ExcuteDataSet(sql);  
    GridView1.DataSource = ds;  
    GridView1.DataBind();  
    //显示记录信息  
    AspNetPager1.CustomInfoHTML = "记录总数：<font color=/"blue/"><b>" + AspNetPager1.RecordCount.ToString() + "</b></font>";    
    AspNetPager1.CustomInfoHTML += " 总页数：<font color=/"blue/"><b>" + AspNetPager1.PageCount.ToString() + "</b></font>";    
    AspNetPager1.CustomInfoHTML += " 当前页：<font color=/"red/"><b>" + AspNetPager1.CurrentPageIndex.ToString() + "</b></font>";   
}  
//执行翻页事件  
protected void AspNetPager1_PageChanged(object sender, EventArgs e)  
{  
    this.GridViewBind();  
}