AspNetPager分页控件没有实现分页的效果？如何解决

Question

后台代码：  protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack )
        {            bind();
        }
    }    private void bind()
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["sql"]);
        string cmd = "select  top 8 * from  img";
        conn.Open();
        SqlDataAdapter da = new SqlDataAdapter(cmd , conn);
        DataSet ds = new DataSet();
        da.Fill(ds, AspNetPager1 .PageSize *(AspNetPager1 .CurrentPageIndex-1) ,AspNetPager1.PageSize , "temptbl");
        DataList1.DataSource = ds.Tables["temptbl"];
        DataList1.DataBind();
        conn.Close();
    }    protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
    {
        AspNetPager1.CurrentPageIndex = e.NewPageIndex;        bind();
        
    }

Answer 1

弄个pagedatesource绑定到aspnetpager

Answer 2

protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
  {
  AspNetPager1.CurrentPageIndex = e.NewPageIndex;
  BindData();
  }
http://topic.csdn.net/u/20100224/16/0205b8b6-3a15-4c78-8be1-ea072be26b53.html

Answer 3

你的查找到的总数没给它吧！
AspNetPager1.RecordCount的值要给！

Answer 4

  protected void AspNetPager1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
        this.AspNetPager1.CurrentPageIndex = e.NewPageIndex;
        this.bind();
    }

Answer 5

AspNetPager还不好用么?那就没有更好的了.这个使用很简单啊.你看看demo啊,AspNetPager1_PageIndexChanged事件是多余的

Answer 6

问题很明显，没有设置RecordCount属性的值，也就是要分页的记录总数，叫它如何分页啊？

Answer 7

protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
  {
  AspNetPager1.CurrentPageIndex = e.NewPageIndex;
  BindData();
  }

Answer 8

本人经常用的
                      
<asp:Repeater ID="repeater1" runat="server" EnableViewState="false">
                        <HeaderTemplate>
                            <table width="371" border="0" cellpadding="0" cellspacing="1" bgcolor="FFFFFF">
                              <tr align="center" bgcolor="#FFCC00"> 
                                <td width="43" height="20"><strong><font color="#FF0000">名次</font></strong></td>
                                <td width="98" height="20"><strong><font color="#FF0000">&nbsp;姓名</font></strong></td>
                                <td width="159" height="20"><strong><font color="#FF0000">证件号码</font></strong></td>
                                <td width="66" height="20"><strong><font color="#FF0000">积分</font></strong></td>
                              </tr>
                        </HeaderTemplate>
                        <ItemTemplate>
                              <tr align="center" bgcolor="#FFCC00"> 
                                <td height="20"><%= Number = Number + 1 %></td>
                                <td height="20"><%# Eval("UserName")%></td>
                                <td height="20"><%# GoldenEgg.Utility.SubString(Eval("UserDoc"),14,false)%></td>
                                <td height="20"><%# Eval("Click")%></td>
                              </tr>
                        </ItemTemplate>
                        <FooterTemplate>
                            </table>
                        </FooterTemplate>
                      </asp:Repeater>
                      <webdiyer:AspNetPager ID="Pager" runat="server" Font-Size="12px" 
                          HorizontalAlign="Center" 
                          InputBoxStyle="border:1px #0000FF solid;text-align:center" 
                          NumericButtonCount="5" NumericButtonTextFormatString="[{0}]"  
                          PagingButtonSpacing="10px" ShowCustomInfoSection="Left" 
                          SubmitButtonStyle="border:1px solid #000066;height:20px;width:30px" 
                          TextAfterInputBox="页" TextBeforeInputBox="第" Width="98%" AlwaysShow="True" 
                          EnableTheming="True" PageSize="90" onpagechanging="Pager_PageChanging" 
                              CustomInfoHTML="" FirstPageText="首页" LastPageText="末页" 
                              ShowPageIndexBox="Auto" LayoutType="Div" NextPageText="后一页" 
                              PrevPageText="前一页" ShowPageIndex="False" ShowMoreButtons="False" 
                              UrlPaging="True">
                      </webdiyer:AspNetPager>
 protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                int page = Request["page"] == null ? 0 : Convert.ToInt32(Request["page"]);
                if (page == 1)
                    page = 0;
                Number = page * 90;
            }
            catch
            {
                Response.Write("页面错误！");
                Response.End();
            }
            if (!this.IsPostBack)
            {
                Bind(0);
            }
        }
        public int n = 0;
        public int Number = 1;
        void Bind(int CurrentPage)
        {
            MPage Pmodel = new MPage();
            Pmodel.CurrentPage = CurrentPage;
            Pmodel.PageSize = Pager.PageSize;
            Pmodel.CountYesNo = true;
            Pmodel.TalleName = "UserInfo";
            Pmodel.Key = "id";
            Pmodel.Field = "";
            //Pmodel.Where = "checkState<>'N' and desksortID=" + desksortID.ToString() + " and pubkind='公开'";
            Pmodel.Orderby = "Click";
            Pmodel.Order = true;
            Paging.List(Pmodel, repeater1, Pager);
            Sponsor_DAL DAL = new Sponsor_DAL();
            repeater.DataSource = DAL.GetList("");
            repeater.DataBind();
        }        protected void Pager_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
        {
            Bind(e.NewPageIndex);
        }

Answer 9

           repeater.DataSource = DAL.GetList("");
            repeater.DataBind();
这个是多余的