DataGrid分页实例（转自孟宪会之精彩世界）

ASP.NET页面

<% @ Page language = " c# "  EnableViewState  =   " true "  Codebehind = " DataGridPaging.aspx.cs "
 AutoEventWireup = " false "  Inherits = " eMeng.Exam.DataGridPaging.DataGridPaging "   %>
<! DOCTYPE HTML PUBLIC  " -//W3C//DTD HTML 4.0 Transitional//EN " >
< HTML >
< HEAD >
< meta content = " Visual Basic 7.0 "  name = " CODE_LANGUAGE " >
< meta content = " JavaScript "  name = " vs_defaultClientScript " >
< meta content = " http://schemas.microsoft.com/intellisense/ie5 "  name = " vs_targetSchema " >
</ HEAD >
< body MS_POSITIONING = " GridLayout " >
< form id = " Form1 "  runat = " server " >
< asp:datagrid id = " MyDataGrid "  runat = " server "  AutoGenerateColumns = " False "
    HorizontalAlign = " Center "  AlternatingItemStyle - BackColor = " #eeeeee "
    HeaderStyle - BackColor = " #aaaadd "  Font - Size = " 8pt "  Font - Name = " Verdana "
    CellSpacing = " 0 "  CellPadding = " 3 "  GridLines = " Both "  BorderWidth = " 1 "
    BorderColor = " black "  OnPageIndexChanged = " MyDataGrid_Page "  PagerStyle - HorizontalAlign = " Right "
    PagerStyle - Mode = " NumericPages "  PageSize = " 5 "  AllowPaging = " True " >
   < AlternatingItemStyle BackColor = " #EEEEEE " ></ AlternatingItemStyle >
   < HeaderStyle BackColor = " #AAAADD "  Font - Bold = " True "  HorizontalAlign = " Center " ></ HeaderStyle >
   < PagerStyle HorizontalAlign = " Right "  Mode = " NumericPages " ></ PagerStyle >
   < Columns >
   < asp:BoundColumn HeaderText = " 标题 "  DataField = " Title "  HeaderStyle - Width = " 480px " >
   </ asp:BoundColumn >
   < asp:BoundColumn HeaderText = " 发表日期 "  DataField = " CreateDate "  DataFormatString = " {0:yyyy-MM-dd hh:mm:ss} " >
   </ asp:BoundColumn >
   </ Columns >
</ asp:datagrid >
< p style = " FONT-SIZE:9pt "  align = " center " >
   < asp:label id = " lblPageCount "  runat = " server " ></ asp:label >& nbsp;
   < asp:label id = " lblCurrentIndex "  runat = " server " ></ asp:label >
   < asp:linkbutton id = " btnFirst "  onclick = " PagerButtonClick "  runat = " server "  Font - Name = " verdana "
      Font - size = " 8pt "  ForeColor = " navy "  CommandArgument = " 0 " ></ asp:linkbutton >& nbsp;
   < asp:linkbutton id = " btnPrev "  onclick = " PagerButtonClick "  runat = " server "  Font - Name = " verdana "
      Font - size = " 8pt "  ForeColor = " navy "  CommandArgument = " prev " ></ asp:linkbutton >& nbsp;
   < asp:linkbutton id = " btnNext "  onclick = " PagerButtonClick "  runat = " server "  Font - Name = " verdana "
      Font - size = " 8pt "  ForeColor = " navy "  CommandArgument = " next " ></ asp:linkbutton >& nbsp;
   < asp:linkbutton id = " btnLast "  onclick = " PagerButtonClick "  runat = " server "  Font - Name = " verdana "
      Font - size = " 8pt "  ForeColor = " navy "  CommandArgument = " last " ></ asp:linkbutton >
</ p >
</ form >
</ body >
</ HTML >

 

--------------------------------------------

后置代码：

 

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;

namespace  eMeng.Exam.DataGridPaging
{
/**//// <summary>
/// DataGridPaging 的摘要说明。
/// </summary>
public class DataGridPaging : System.Web.UI.Page
{
 protected System.Web.UI.WebControls.DataGrid MyDataGrid;
 protected System.Web.UI.WebControls.Label lblPageCount;
 protected System.Web.UI.WebControls.Label lblCurrentIndex;
 protected System.Web.UI.WebControls.LinkButton btnFirst;
 protected System.Web.UI.WebControls.LinkButton btnPrev;
 protected System.Web.UI.WebControls.LinkButton btnNext;
 protected System.Web.UI.WebControls.LinkButton btnLast;
 private OleDbConnection cn = new OleDbConnection();

private void Page_Load(object sender, System.EventArgs e)
{
  // 在此处放置用户代码以初始化页面
  btnFirst.Text = "最首页";
  btnPrev.Text = "前一页";
  btnNext.Text = "下一页";
  btnLast.Text = "最后页";
  OpenDatabase();
  BindGrid();
}
private void OpenDatabase()
{
 cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("xxxx.mdb");
 cn.Open();
}
private void ShowStats()
{
 lblCurrentIndex.Text = "第 " + (MyDataGrid.CurrentPageIndex + 1).ToString() + " 页";
 lblPageCount.Text = "总共 " + MyDataGrid.PageCount.ToString() + " 页";
}

public void PagerButtonClick(object sender, EventArgs e)
{
 string arg = ((LinkButton)sender).CommandArgument.ToString();
 switch(arg)
 {
  case "next":
   if (MyDataGrid.CurrentPageIndex < (MyDataGrid.PageCount - 1))
   {
    MyDataGrid.CurrentPageIndex += 1;
   }
   break;
  case "prev":
   if (MyDataGrid.CurrentPageIndex > 0)
   {
    MyDataGrid.CurrentPageIndex -= 1;
   }
   break;
  case "last":
   MyDataGrid.CurrentPageIndex = (MyDataGrid.PageCount - 1);
   break;
  default:
   MyDataGrid.CurrentPageIndex = System.Convert.ToInt32(arg);
   break;
 }
 BindGrid();
 ShowStats();
}
public void BindGrid()
{
 OleDbConnection myConnection = cn;
 DataSet ds  = new DataSet();
 OleDbDataAdapter adapter  = new OleDbDataAdapter("Select Title,CreateDate from Document", myConnection);
 adapter.Fill(ds, "Document");
 MyDataGrid.DataSource = ds.Tables["Document"].DefaultView;
 MyDataGrid.DataBind();
 ShowStats();
}
public void MyDataGrid_Page(object sender, DataGridPageChangedEventArgs e)
{
 int startIndex ;
 startIndex = MyDataGrid.CurrentPageIndex * MyDataGrid.PageSize;
 MyDataGrid.CurrentPageIndex = e.NewPageIndex;
 BindGrid();
 ShowStats();
}

Web Form Designer generated code#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
}
}