DataGrid自定义分页（C#）

DataGrid自定义分页（C#）
                                      
当需要查查看每一页时，只从数据源提取要显示于该页面的数据记录
设置与原则：
1、AllowPaging设置成True，另外，AllowCustonPaging也设置为True，允许自定义分页
2、把数据源的数据记录数赋值给DataGrid的VirtuallItemCount属性
3、DataGrid控件绑定至数据源

C＃：
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace eMeng.Exam.DataGridPaging
{
 /// <summary>
 /// DataGridPaging 的摘要说明。
 /// </summary>
 public class DataGridPaging : System.Web.UI.Page
 {
  protected System.Web.UI.WebControls.DataGrid DataGrid1;
  protected System.Web.UI.WebControls.Button Btnprev;
  protected System.Web.UI.WebControls.Button BtnNext;
  private int StartIndex;
  private SqlConnection MyConn = null;
  private void Page_Load(object sender, System.EventArgs e)
  {
　   /// 在此处放置用户代码以初始化页面
   this.Btnprev.Click+=new System.EventHandler(this.GotoPage);
   this.BtnNext.Click+=new System.EventHandler(this.GotoPage);
   if (!IsPostBack)
   {
    StartIndex = 0;
    MyConn = new SqlConnection("server = localhost; uid = sa; pwd = ; database = northwind");
    SqlCommand MyComm = new SqlCommand("select RecordTotal = count(*) from orders",MyConn);
    MyConn.Open();
    SqlDataReader dr = MyComm.ExecuteReader(CommandBehavior.SingleRow);
    if (dr.Read())
    {
     DataGrid1.VirtualItemCount = (int)dr["RecordTotal"];
    }
    dr.Close();
    MyConn.Close();
    BindGridToSource(StartIndex,"上一页");
   }
  }
  private void GotoPage(object sender, System.EventArgs e)
  {
   string PageInfo = ((Button)sender).CommandName;
   switch(PageInfo)
   {
    case "上一页":
     if(DataGrid1.CurrentPageIndex>0)
      DataGrid1.CurrentPageIndex-=1;
     break;
    case "下一页":
     if (DataGrid1.CurrentPageIndex<(DataGrid1.PageCount-1))
      DataGrid1.CurrentPageIndex+=1;
     else
      return;
    break;
   }
   StartIndex = DataGrid1.CurrentPageIndex*DataGrid1.PageSize;
   BindGridToSource(StartIndex,PageInfo);
  }
  private void BindGridToSource(int StartPosition, string GoPage)
  {
   MyConn = new SqlConnection("server = localhost; uid = sa; pwd = ; database = northwind");
   SqlCommand MyComm = null;
   switch(GoPage)
   {
    case "上一页":
     MyComm = new SqlCommand("select top 5 orderid,customerid,employeeid,orderdate,requireddate from orders "+
      "where orderid >= @uid order by orderid",MyConn);
     if (StartPosition == 0)
      MyComm.Parameters.Add("@uid",SqlDbType.NVarChar,5).Value = "";
     else
      MyComm.Parameters.Add("@uid",SqlDbType.NVarChar,5).Value =
       ViewState[(DataGrid1.CurrentPageIndex+1).ToString()];
     break;
    case "下一页":
     MyComm = new SqlCommand("select top 5 orderid,customerid,employeeid,orderdate,requireddate from orders "+
      "where orderid > @uid order by orderid",MyConn);
     MyComm.Parameters.Add("@uid",SqlDbType.NVarChar,
      18).Value = DataGrid1.Items[4].Cells[0].Text;
     break;
   }
   MyConn.Open();
   SqlDataReader dr = MyComm.ExecuteReader();
   DataGrid1.DataSource = dr;
   DataGrid1.DataBind();
   dr.Close();
   MyConn.Close();
   ViewState[(DataGrid1.CurrentPageIndex + 1).ToString()] =
    DataGrid1.Items[0].Cells[0].Text;
  }

  #region Web Form Designer generated code
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {
   this.Load += new System.EventHandler(this.Page_Load);
  }
  #endregion
 }
}