如何使用AspNetPager分页控件使以下代码实施分页效果

Question

AspNetPager控件     
    <webdiyer:AspNetPager CssClass="pages" 
                            CurrentPageButtonClass="cpb" ID="AspNetPager1" runat="server" 
                            AlwaysShow="True" AlwaysShowFirstLastPageNumber="True" FirstPageText="首页" 
              LastPageText="尾页" NextPageText="下一页" PageSize="20" PrevPageText="上一页" 
                            NumericButtonCount="5" onpagechanged="AspNetPager1_PageChanged" >
                        </webdiyer:AspNetPager>
后台代码
 public string list = string.Empty;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.QueryString["id"] != null)
            {
                string id = Request.QueryString["id"].ToString();
                string sql = "select * from CaseInformation where id=" + id;
                SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["NOKIAConnectionString"].ConnectionString);
                SqlCommand cmd = new SqlCommand(sql, conn);
                SqlDataAdapter sda = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                sda.Fill(ds);
                list += "<div class=\"ta_con left\">";
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    list += "<div class=\"n_title\">" + dr["title"].ToString() + "</div><!--//n_title-->" +
                    "<div class=\"n_time\">新闻来源：学友传媒 发布时间：" + dr["time"].ToString().Substring(0, 9) + "</div><!--//n_time-->" +
                    "<span class=\"text_1\">" + dr["Pictures"].ToString() + "</span>";
                }
                list += "</div>";
            }
        }
    }

Answer 1

Page_Load  里获得总页数给  AspNetPager 设置上，
AspNetPager1_PageChanged 事件里 
根据 e.newpageindex 去数据库获取数据，并拼接 list 显示到页面

Answer 2

private int RecordCount;  //总数据量
protected void Page_Load(object sender, EventArgs e)
{
   if (!Page.IsPostBack)
  {
       InfoBind(1);
   }
}protected void AspNetPagerHotel_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
{  InfoBind(e.NewPageIndex); }
private void InfoBind(int CurrentPage)
{
     datatable tb=getData(CurrentPage,out RecordCount);   连数据库获得tb 很 总数据量     根据 tb 拼接 list ......     AspNetPager.RecordCount = RecordCount;
     AspNetPager.CurrentPageIndex=CurrentPage;}

Answer 3

我的.cs代码如下，参考修改就可以了
 protected void Page_Load(object sender, EventArgs e)
    {
        Label1.ToolTip = "版权所有：南丰中学  程序:林培昌";
        try
        {
            if (!Page.IsPostBack)
            {
                sqlcon = new SqlConnection(strCon);
                sqlcon.Open();
                sqlcom = new SqlCommand();
                sqlcom.Connection = sqlcon;
                sqlcom.CommandText = "select count(*) from systemlog";//查询表
                AspNetPager1.AlwaysShow = true;
                //AspNetPager1.PageSize = 5;
                AspNetPager1.RecordCount = (int)sqlcom.ExecuteScalar();
                sqlcon.Close();
                RepeaterDataBind();                string exit_time_idstr = "select top 1 id from systemlog order by login_time desc";
                SqlDataAdapter myda = new SqlDataAdapter(exit_time_idstr, sqlcon);
                DataSet myds = new DataSet();
                sqlcon.Open();
                myda.Fill(myds, "systemlog");
                sqlcon.Close();
                            }
        }
        catch (Exception ex)
        {
            Label1.Text = ex.Message;
        }
    }
 private void RepeaterDataBind()
    {//绑定
        string rz_sqlstr = "select * from systemlog order by id desc ";
         dr = new SqlDataAdapter(rz_sqlstr, strCon);
        ds = new DataSet();
        dr.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "systemlog");
        this.GridView1.DataSource = ds.Tables["systemlog"];
        this.GridView1.DataBind();        AspNetPager1.CustomInfoHTML = " 总页数:<b>" + AspNetPager1.PageCount.ToString() + "</b>";
        AspNetPager1.CustomInfoHTML += " 当前页:<font color=\"red\"><b>" + AspNetPager1.CurrentPageIndex.ToString() + "</b></font>";
    }    protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
    {
        AspNetPager1.CurrentPageIndex = e.NewPageIndex;
        RepeaterDataBind();
    }
    protected void AspNetPager1_PageChanged(object sender, EventArgs e)
    {//分页发生改变时触发事件
        RepeaterDataBind();
    }

Answer 4

sqlcon 这东西 哪里来的  没有定义过你怎么用的？

Answer 5

  SqlConnection  sqlcon   你定义一个不就行了

Answer 6

为webdiyer:AspNetPager控件的PageChanging事件提供数据无法继承此类，出现这种情况怎么解决呢？