急AspNetPager DataList 分页问题

[Yzak0Jule]

能否给一个比较详细点的，网上的代码都很零乱，刚学不久 没那么好的领悟能力
datalist 的分页
表 Tb_News

    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;
        }

这些是网上找的代码，但按照他说的做了，但还是实现不了，缺少了些什么吗？求指教啊。。。

[yanxiaodi]

他自带的sample里都有啊，很详细，再仔细看看

[wuyq11]

aspnetpager中就有相关实例

[webdiyer]

http://www.webdiyer.com/controls/aspnetpager

[智者知已应修善业]

http://blog.csdn.net/xianfajushi/archive/2011/01/10/6127859.aspx

[major]

应该还缺少一段AspNetPager1_PageChanged事件的

[talent1314]

它只要是以分页为主的 代码在下面了 但是你在下面查的时候还是要仔细看看的
OleDbConnection con =new OleDbConnection("Provider=Microsoft.Jet.OleDB.4.0;" + "Data Source="+Server.MapPath("~/DataBase/DB.mdb"));
con.Open();
OleDbDataAdapter da = new OleDbDataAdapter(你的SQL语句,con);
DataSet ds = new DataSet();
da.Fill(ds,"News");
//创建分页类
PagedDataSource objPage = new PagedDataSource();
//设置数据源
objPage.DataSource = ds.Tables["News"].DefaultView;
//开启分页
objPage.AllowPaging = true;
//显示显示的行数
objPage.PageSize = 20;
//定义变量保存当前页索引
int curPage;
//判断当前页是否有跳转请求
if (Request.QueryString["Page"] != null)
curPage = Convert.ToInt32(Request.QueryString["Page"]);
else
curPage = 1;
objPage.CurrentPageIndex = curPage - 1;
this.Label1.Text = curPage.ToString();
this.Label2.Text = objPage.PageCount.ToString();
if (!objPage.IsFirstPage)
{ //定义"上一页"超级连接的URL为:当前执行页面的虚拟路径,并传递下一页面的索引植

this.HyperLink1.NavigateUrl = Request.CurrentExecutionFilePath + "?name=" + Request.QueryString["name"]+"&Page="+Convert.ToString(curPage - 1);
}
if (!objPage.IsLastPage)
{
//下一页
this.HyperLink2.NavigateUrl = Request.CurrentExecutionFilePath + "?name=" + Request.QueryString["name"]+"&Page="+Convert.ToString(curPage + 1);
}
this.HyperLink3.NavigateUrl = Request.CurrentExecutionFilePath + "?name=" + Request.QueryString["name"]+"&Page=" + Convert.ToString(objPage.PageCount);
this.DataList1.DataSource = objPage;
this.DataList1.DataBind();