急AspNetPager DataList 分页问题

    protected void Page_Load(object sender, EventArgs e)

    {

        int id = Convert.ToInt32(6);

        BindData(id);



        BindDataList();

    }



    public void BindDataList()

    {

        string sql = "select * from gw_newsletter_group";//自定义的SQL语句

        int recordcount;

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

        this.AspNetPager1.RecordCount = recordcount;

        this.Datalist1.DataSource = ds;

        this.Datalist1.DataBind();

        AspNetPager1.CustomInfoHTML = "记录总数：<b>" + AspNetPager1.RecordCount.ToString() + "</b>";

        AspNetPager1.CustomInfoHTML += " 总页数：<b>" + AspNetPager1.PageCount.ToString() + "</b>";

        AspNetPager1.CustomInfoHTML += " 当前页：<font color=\"red\"><b>" + AspNetPager1.CurrentPageIndex.ToString() + "</b></font>";

    }



    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;

    }







        /// <summary>

        /// Get Data By CurrentPage

        /// </summary>

        /// <param name="sql">SQL</param>

        /// <param name="currentPage">current Page</param>

        /// <param name="pagesize">Page Size</param>

        /// <param name="recordcount">Total Record</param>

        /// <returns></returns>

        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;

        }