asp.net AspNetpager的用法

前台代码：

<webdiyer:AspNetPager ID="AspNetPager1" runat="server" FirstPageText="首页" LastPageText="尾页"

     NextPageText="下一页" PrevPageText="上一页" HorizontalAlign="Center" OnPageChanged="AspNetPager1_PageChanged"

        PageIndexBoxType="DropDownList" ShowPageIndexBox="Always" UrlPaging="True"

        ShowNavigationToolTip="True" PageSize="1">

    </webdiyer:AspNetPager>

后台代码：

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            BindGridView();

        }

    }

    public void BindGridView()

    {

        string sql = "select ID,SmallClassID,NewsTitle,Checked,Commend,AddTime from NewsAdd";//自定义的SQL语句

        int recordcount;

        DataSet ds = GetPage(sql, this.AspNetPager1.CurrentPageIndex, this.AspNetPager1.PageSize, out recordcount);

        this.AspNetPager1.RecordCount = recordcount;

        this.Repeater1.DataSource = ds;

        this.Repeater1.DataBind();

    }

    public DataSet GetPage(string sql, int currentPage, int pagesize, out int recordcount)

    {

        SqlDataAdapter ada = new SqlDataAdapter(sql, GetConnection());

        DataSet ds = new DataSet();

        int startRow = (currentPage - 1) * pagesize;

        ada.Fill(ds, startRow, pagesize, "table");

        recordcount = GetPageRecord(sql);

        return ds;

    }

    public int GetPageRecord(string sql)

    {

        sql = System.Text.RegularExpressions.Regex.Replace(sql, "order by.*", "");

        sql = "select count(*) from (" + sql + ") as temp";

        SqlCommand cmd = new SqlCommand(sql, GetConnection());

        cmd.Connection.Open();

        int recordcount = (int)cmd.ExecuteScalar();

        return recordcount;

    }

    protected void AspNetPager1_PageChanged(object sender, EventArgs e)

    {

        BindGridView();

    }

    public SqlConnection GetConnection() //获得SqlConnection对象

    {

        return new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString());

    }