- 爱易网页
 
                        - 
                            C#教程
 
                        - .net datalist分页有关问题,设置了allowPaging=true,pagesize也设置了但是所有的数据还是在一个页面显示 
 
                         
                    
                    
                    日期:2014-05-18  浏览次数:21263 次 
                    
                        
                         .net datalist分页问题,设置了allowPaging=true,pagesize也设置了但是所有的数据还是在一个页面显示,求助
前台代码:<div  
                 当前页码为:<asp:Label ID="Label1" runat="server" Text="1"></asp:Label>
              总页码为:<asp:Label ID="Label2" runat="server" Text=""></asp:Label>
                 <asp:LinkButton ID="LinkButtonFirst" runat="server"  
                     onclientclick="LinkButtonFirst_Click" onclick="LinkButtonFirst_Click">第一页</asp:LinkButton>
              
                 <asp:LinkButton ID="LinkButtonPrev" runat="server"  
                     onclientclick="LinkButtonPrev_Click" onclick="LinkButtonPrev_Click">上一页</asp:LinkButton>
              
                 <asp:LinkButton ID="LinkButtonNext" runat="server"  
                     onclientclick="LinkButtonNext_Click" onclick="LinkButtonNext_Click">下一页</asp:LinkButton>
              
                 <asp:LinkButton ID="LinkButtonLast" runat="server"  
                     onclientclick="LinkButtonLast_Click" onclick="LinkButtonLast_Click">最后一页</asp:LinkButton>  </div>
后台代码:
public partial class test10 : System.Web.UI.Page
{
     protected void Page_Load(object sender, EventArgs e)
     {
         if (!IsPostBack)
         {
             listbind();
         }
     }
     void listbind()
     { PagedDataSource pages = new PagedDataSource();
         string sqlconnstr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
         SqlDataAdapter sqld = new SqlDataAdapter("select * from products", sqlconnstr);
         DataSet ds = new DataSet();
         sqld.Fill(ds, "sql");
         using (SqlConnection sqlconn = new SqlConnection(sqlconnstr))
         {
             pages.DataSource = ds.Tables[0].DefaultView;
             pages.AllowPaging = true;
             pages.PageSize = 6;
             int Curpage = Convert.ToInt32(this.Label1.Text);
             pages.CurrentPageIndex = Curpage - 1;
             if (pages.CurrentPageIndex < 0)
             {
                 pages.CurrentPageIndex = 0;
             }//只有一页时禁用上下页  
             if (pages.PageCount == 1)
             {
                 LinkButtonPrev.Enabled = false;
                 LinkButtonNext.Enabled = false;
             }
             else //多页时
             {
                 //为第一页时
                 if (Curpage == 1)
                 {
                     LinkButtonPrev.Enabled = false;
                     LinkButtonNext.Enabled = true;
                 }
                 //为最后一页时
                 if (Curpage == pages.PageCount)
                 {
                     LinkButtonPrev.Enabled = true;
                     LinkButtonNext.Enabled = false;
                 }
             }
             this.Label2.Text = Convert.ToString(pages.PageCount);
                  
             DataList1.DataBind();
     
            }
  }
     //首页
  protected void LinkButtonFirst_Click(object sender, EventArgs e)
     {