下面的代码,
跳转页有效而上一页下一页都无效,根本读不出数据,不知道什么原因,谢谢大家帮我看看,谢谢
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++    //当前页
    private int iCurrentPage = 1;
    //记录数
    private int iRecordCount =1000000;
    //每页大小
    private int PageSize = 20;    // 跳转到指定的页    protected void btnGo_Click(object sender, EventArgs e)
    {
        try
        {
            iCurrentPage = Convert.ToInt32(nudSize.Text);
            ReadData(iCurrentPage);
        }
        catch (Exception err)
        {
            Response.Write("<script>alert('跳转到指定的页时异常操作')</script>");
        }
    }    // 下一页    protected void btnNext_Click(object sender, EventArgs e)
    {
        try
        {
            if (iCurrentPage < ((iRecordCount / PageSize) + 1))
            {
                iCurrentPage += 1;
                nudSize.Text= iCurrentPage.ToString();
                ReadData(iCurrentPage);
            }
        }
        catch (Exception err)
        {
            Response.Write("<script>alert('下一页异常操作')</script>");
        }
    }  //读指定页的记录    private bool ReadData(int iPage)
    {
        try
        {            dgResult.DataSource = GreatDataPage("News", "newsid,filenames,senduser", "newsid", PageSize, Convert.ToInt32(nudSize.Text), 0, " ").Tables[0];
            dgResult.DataBind();
            return true;
        }
        catch (Exception err)
        {
            Response.Write("<script>alert('获取指定页记录时异常操作')</script>");
            return false;
        }
    }
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

解决方案 »

  1.   

    每次我都用到了这个方法啊
    ReadData(int iPage)
    里面不是每次都绑定了数据源吗dgResult.DataBind();
      

  2.   

    我用SQL的事件探察器跟踪了
    只有在跳转的时候才执行存储过程:GreatDataPage,上下一页都没有
      

  3.   

    下一页这样改可以了呵呵
    +++++++++++++++++++++++++++++++++++++++++++++
    try
            {
                if (iCurrentPage < ((iRecordCount / PageSize) + 1))
                {
                    iCurrentPage = Convert.ToInt32(nudSize.Text)+1;
                    ReadData(iCurrentPage);
                    nudSize.Text = iCurrentPage.ToString();
                }
            }
            catch (Exception err)
            {
                Response.Write("<script>alert('下一页异常操作')</script>");
            }但是上一页还有问题+++++++++++++++++++++++++++++++++++++++++++++
     try
            {
                if (iCurrentPage > 1)
                {
                    iCurrentPage = Convert.ToInt32(nudSize.Text) - 1;
                    ReadData(iCurrentPage);
                    nudSize.Text = iCurrentPage.ToString();
                }
            }
            catch (Exception err)
            {
                Response.Write("<script>alert('上一页异常操作')</script>");
            }