asp.net为何分页后不能显示下一页？

<%@ Register TagPrefix="webdiyer" Namespace="Wuqi.Webdiyer" Assembly="AspNetPager" %>
<%@ Register TagPrefix="webOleDb" Namespace="OleDb" Assembly="DBClass" %>
<%@ Import NameSpace="System"%>
<%@ Import NameSpace="System.Data"%>
<%@ Import NameSpace="System.Web"%>
<%@ Import NameSpace="System.Data.OleDb"%>
<script language="c#" runat="server">
void Page_Load(Object sender,EventArgs e)
  {
DataAccess DA=new DataAccess("/w1.mdb");
DataSet ds = new DataSet();
ds = DA.GetDataSet("select * from oblog_comment","oblog_comment"); this.AspNetPager1.RecordCount = ds.Tables[0].Rows.Count;
DA.Close();
BindData();
  }
void BindData() 
{
DataAccess DA=new DataAccess("/w1.mdb");
DataSet ds = new DataSet();
ds = DA.GetDataSet("select * from oblog_comment",AspNetPager1.PageSize*(AspNetPager1.CurrentPageIndex-1),AspNetPager1.PageSize,"oblog_comment"); this.dgrdMain.DataSource=ds.Tables["oblog_comment"]; 
this.dgrdMain.DataBind();//  AspNetPager1.CustomInfoText="记录总数：<font color=\"blue\"><b>"+AspNetPager1.RecordCount.ToString()+"</b></font>"; 
  // AspNetPager1.CustomInfoText+=" 总页数：<font color=\"blue\"><b>"+AspNetPager1.PageCount.ToString()+"</b></font>"; 
   //AspNetPager1.CustomInfoText+=" 当前页：<font color=\"red\"><b>"+AspNetPager1.CurrentPageIndex.ToString()+"</b></font>"; 
}
  private void AspNetPager1_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e) 
  { 
   AspNetPager1.CurrentPageIndex=e.NewPageIndex; 
   BindData(); 
   System.Text.StringBuilder sb=new StringBuilder("<script Language=\"Javascript\"><!--\n"); 
   sb.Append("var el=document.all;"); 
   sb.Append(this.dgrdMain.ClientID); 
   sb.Append(".scrollIntoView(true);"); 
   sb.Append("<"); 
   sb.Append("/"); 
   sb.Append("script>"); 
   if(!Page.IsStartupScriptRegistered("scrollScript")) 
    Page.RegisterStartupScript("scrollScript",sb.ToString()); 
  } 
  </script><html> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"> 
<title>测试</title> 
</head> 
<body>  <asp:DataGrid   id="dgrdMain"   cellpadding="1"   showheader="true"   autogeneratecolumns="False"  borderwidth="1"  runat="server">
  <columns>
  <asp:boundcolumn datafield="comment"/>
  <asp:boundcolumn datafield="addtime"/>
  </columns>
  </asp:datagrid> 
<form runat="server"> 
<asp:label id="comment1" runat="server"></asp:label> 
<asp:label id="commenttopic1" runat="server"></asp:label> 
<webdiyer:aspnetpager id="AspNetPager1" runat="server" PageSize="5" UrlPaging="True" ShowBoxThreshold="10"></webdiyer:aspnetpager>
</form> 
</body> 
</html> 
DBClass.csusing System;
using System.Data.OleDb;
using System.Data;
using System.Web;
namespace DBClass
{
/// <summary>
/// DataAccess 的摘要说明。
/// </summary>
public class DBClass
{
//省去若干程序....
public DataSet GetDataSet(string sqlStr,int StartIndex,int PageSize,string tableName)
{
DataSet dataset = new DataSet();
OleDbCommand cmd = CreateCommand(sqlStr);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(cmd);
dataAdapter.Fill(dataset,StartIndex,PageSize,tableName);
cmd.Dispose();
Close();
dataAdapter.Dispose();
return dataset;
}
/// 执行带有参数的分页的数据库查询
/// </summary>
/// <param name="sqlStr">SQL查询语句</param>
/// <param name="StartIndex">当前页</param>
/// <param name="PageSize">页大小</param>
/// <param name="tableName">填充数据集表格的名称</param>
/// <param name="parame">参数数组</param>
/// <returns>返回整个数据集</returns>
public DataSet GetDataSet(string sqlStr,int StartIndex,int PageSize,string tableName,OleDbParameter[] parame)
{
DataSet dataset = new DataSet();
OleDbCommand cmd = CreateCommand(sqlStr,parame);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(cmd);
dataAdapter.Fill(dataset,StartIndex,PageSize,tableName);
cmd.Dispose();
Close();
dataAdapter.Dispose();
return dataset;
}
/// <summary>
/// 关闭数据库
/// </summary>
public void Close()
{
if(con!=null)
con.Close();
}
/// <summary>
/// 释放资源
/// </summary>
public void Dispose()
{
if(con!=null)
{
con.Dispose();
con=null;
}
}
}
}详情请见：http://www.zgso.com/std/wpage.aspx高手快救!!!!!

解决方案 »

  1.   

    在PAGE_LOAD事件
    if (this.IsPostBack == false)
    {
    你的代码
    }
      

  2.   

    <%@ Register TagPrefix="webdiyer" Namespace="Wuqi.Webdiyer" Assembly="AspNetPager" %>
    <%@ Register TagPrefix="webOleDb" Namespace="OleDb" Assembly="DBClass" %>
    <%@ Import NameSpace="System"%>
    <%@ Import NameSpace="System.Data"%>
    <%@ Import NameSpace="System.Web"%>
    <%@ Import NameSpace="System.Data.OleDb"%>
    <script language="c#" runat="server">
    void Page_Load(Object sender,EventArgs e)
      {
       if(!Page.IsPostBack ) 
       { 
    DataAccess DA=new DataAccess("/w1.mdb");
    DataSet ds = new DataSet();
    ds = DA.GetDataSet("select * from oblog_comment","oblog_comment");
    this.AspNetPager1.RecordCount = ds.Tables[0].Rows.Count;
    DA.Close();
    BindData();
       } 
      } void BindData() 
    {
    DataAccess DA=new DataAccess("/w1.mdb");
    DataSet ds = new DataSet();
    ds = DA.GetDataSet("select * from oblog_comment",AspNetPager1.PageSize*(AspNetPager1.CurrentPageIndex-1),AspNetPager1.PageSize,"oblog_comment"); this.dgrdMain.DataSource=ds.Tables["oblog_comment"]; 
    this.dgrdMain.DataBind();//  AspNetPager1.CustomInfoText="记录总数：<font color=\"blue\"><b>"+AspNetPager1.RecordCount.ToString()+"</b></font>"; 
      // AspNetPager1.CustomInfoText+=" 总页数：<font color=\"blue\"><b>"+AspNetPager1.PageCount.ToString()+"</b></font>"; 
       //AspNetPager1.CustomInfoText+=" 当前页：<font color=\"red\"><b>"+AspNetPager1.CurrentPageIndex.ToString()+"</b></font>"; 
    }
      private void AspNetPager1_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e) 
      { 
       AspNetPager1.CurrentPageIndex=e.NewPageIndex; 
       BindData(); 
       System.Text.StringBuilder sb=new StringBuilder("<script Language=\"Javascript\"><!--\n"); 
       sb.Append("var el=document.all;"); 
       sb.Append(this.dgrdMain.ClientID); 
       sb.Append(".scrollIntoView(true);"); 
       sb.Append("<"); 
       sb.Append("/"); 
       sb.Append("script>"); 
       if(!Page.IsStartupScriptRegistered("scrollScript")) 
        Page.RegisterStartupScript("scrollScript",sb.ToString()); 
      } 
      </script><html> 
    <head> 
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> 
    <title>测试</title> 
    </head> 
    <body>  <asp:DataGrid   id="dgrdMain"   cellpadding="1"   showheader="true"   autogeneratecolumns="False"  borderwidth="1"  runat="server">
      <columns>
      <asp:boundcolumn datafield="comment"/>
      <asp:boundcolumn datafield="addtime"/>
      </columns>
      </asp:datagrid> 
    <form runat="server"> 
    <asp:label id="comment1" runat="server"></asp:label> 
    <asp:label id="commenttopic1" runat="server"></asp:label> 
    <webdiyer:aspnetpager id="AspNetPager1" runat="server" PageSize="5" UrlPaging="True" ShowBoxThreshold="10"></webdiyer:aspnetpager>
    </form> 
    </body> 
    </html>
      

  3.   

    成功了
    发现问题
    <webdiyer:aspnetpager id="AspNetPager1" runat="server" PageSize="5" UrlPaging="True" ShowBoxThreshold="10"></webdiyer:aspnetpager>改为
    <webdiyer:aspnetpager id="AspNetPager1" runat="server" PageSize="5" UrlPaging="True" ShowBoxThreshold="10" OnPageChanged="ChangePage"></webdiyer:aspnetpager>