DataGrid分页数据库存储过程而实现的分页 和sp_cursor 分页

 

private   void  Page_Load( object  sender, System.EventArgs e)
... {
   OpenDatabase();
   BindGrid();
   this.count.Text = "您搜索出 "+ds.Tables[0].Rows.Count.ToString()+" 条记录";
}
  private   void  OpenDatabase() 
   ... { 
   cn = new SqlConnection(C.ConfigurationSettings.AppSettings[0]);
   cn.Open();
  }  

public   void  BindGrid() 
         ... { 
            ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter(sql,cn);
            da.Fill(ds,"Document");
            this.Datagrid2.DataSource = ds.Tables["Document"].DefaultView;
            this.Datagrid2.DataBind();
            ShowStats(); 
        }  
private   void  ShowStats() 
         ... { 
            lblCurrentIndex.Text = "第 " + (DataGrid2.CurrentPageIndex + 1).ToString() + " 页"; 
            
            lblPageCount.Text = "总共 " + DataGrid2.PageCount.ToString() + " 页"; 
        }  

// 上页下页最前最后按钮事件
private   void  Button_Click( object  sender, System.Web.UI.ImageClickEventArgs e)
         ... {
            string  arg = ((ImageButton)sender).CommandArgument.ToString();
            switch(arg)
            ...{
                case ("first"):
                    DataGrid2.CurrentPageIndex = 0;
                    
                    break;
                case ("prev"):
                    if(DataGrid2.CurrentPageIndex>0)
                    ...{
                        DataGrid2.CurrentPageIndex--;
                        
                    }    
                    break;
                case ("next"):
                    if(DataGrid2.CurrentPageIndex<(DataGrid2.PageCount-1))
                    ...{
                        DataGrid2.CurrentPageIndex++;
                        
                    }
                    break;
                case ("last"):
                    DataGrid2.CurrentPageIndex = DataGrid2.PageCount-1;
                    
                    break;
                default:
                    DataGrid2.CurrentPageIndex = Convert.ToInt32(arg);
                    
                    break;
            }
            BindGrid();
            this.ShowStats();
        
        }

private   void  OnPageIndexChanged( object  source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
         ... {
            int startIndex ;
            startIndex = DataGrid2.CurrentPageIndex * DataGrid2.PageSize;
            DataGrid2.CurrentPageIndex = e.NewPageIndex;
            BindGrid();
            ShowStats();
        }
// 按钮go的代码
private   void  go_Click( object  sender, System.Web.UI.ImageClickEventArgs e)
             ... {
                if(to.Text.Trim()!="")
                ...{   
                    int index=Int32.Parse(to.Text.Trim())-1;
                    if(index>=0&&index<DataGrid2.PageCount)
                    ...{
                        DataGrid2.CurrentPageIndex=index;
                    }
                }
                BindGrid();
            }

//在窗体设计器生成的代码中加入
                                                                 this .First.Click  +=   new  System.Web.UI.ImageClickEventHandler( this .Button_Click);
             this .Prev.Click  +=   new  System.Web.UI.ImageClickEventHandler( this .Button_Click);
             this .Next.Click  +=   new  System.Web.UI.ImageClickEventHandler( this .Button_Click);
             this .Last.Click  +=   new  System.Web.UI.ImageClickEventHandler( this .Button_Click);
                                                                 this .go.Click  +=   new  System.Web.UI.ImageClickEventHandler( this .go_Click);
                                                                 this .DataGrid2.PageIndexChanged  +=   new  System.Web.UI.WebControls.DataGridPageChangedEventHandler( this .OnPageIndexChanged);