一个功能齐全的DataGrid分页例子(两种方法)

方法一:

DataGridPaging.aspx

1@ Page language="c#" EnableViewState = "true" Codebehind="DataGridPaging.aspx.cs"   
2AutoEventWireup="false" Inherits="eMeng.Exam.DataGridPaging.DataGridPaging" 
 1<html>
 2<head>
 3<meta content="Visual Basic 7.0" name="CODE_LANGUAGE"/>
 4<meta content="JavaScript" name="vs_defaultClientScript"/>
 5<meta content=" http://schemas.microsoft.com/intellisense/ie5 " name="vs_targetSchema"/>
 6</head>
 7<body ms_positioning="GridLayout">
 8<form id="Form1" runat="server">
 9<asp:datagrid allowpaging="True" alternatingitemstyle-backcolor="#eeeeee" autogeneratecolumns="False" bordercolor="black" borderwidth="1" cellpadding="3" cellspacing="0" font-name="Verdana" font-size="8pt" gridlines="Both" headerstyle-backcolor="#aaaadd" horizontalalign="Center" id="MyDataGrid" onpageindexchanged="MyDataGrid_Page" pagerstyle-horizontalalign="Right" pagerstyle-mode="NumericPages" pagesize="5" runat="server">
10<alternatingitemstyle backcolor="#EEEEEE"></alternatingitemstyle>
11<headerstyle backcolor="#AAAADD" font-bold="True" horizontalalign="Center"></headerstyle>
12<pagerstyle horizontalalign="Right" mode="NumericPages"></pagerstyle>
13<columns>
14<asp:boundcolumn datafield="Title" headerstyle-width="480px" headertext="标题">
15</asp:boundcolumn>
16<asp:boundcolumn datafield="CreateDate" dataformatstring="{0:yyyy-MM-dd hh:mm:ss}" headertext="发表日期">
17</asp:boundcolumn>
18</columns>
19</asp:datagrid>
20<p align="center" style="FONT-SIZE:9pt">
21<asp:label id="lblPageCount" runat="server"></asp:label>    
22<asp:label id="lblCurrentIndex" runat="server"></asp:label>
23<asp:linkbutton commandargument="0" font-name="verdana" font-size="8pt" forecolor="navy" id="btnFirst" onclick="PagerButtonClick" runat="server"></asp:linkbutton>    
24<asp:linkbutton commandargument="prev" font-name="verdana" font-size="8pt" forecolor="navy" id="btnPrev" onclick="PagerButtonClick" runat="server"></asp:linkbutton>    
25<asp:linkbutton commandargument="next" font-name="verdana" font-size="8pt" forecolor="navy" id="btnNext" onclick="PagerButtonClick" runat="server"></asp:linkbutton>    
26<asp:linkbutton commandargument="last" font-name="verdana" font-size="8pt" forecolor="navy" id="btnLast" onclick="PagerButtonClick" runat="server"></asp:linkbutton>
27</p>
28</form>
29</body>
30</html>

DataGridPaging.aspx.cs

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
{
///

1<summary>   
2/// DataGridPaging 的摘要说明。   
3/// </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();
}

#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}

///

1<summary>   
2/// 设计器支持所需的方法 - 不要使用代码编辑器修改   
3/// 此方法的内容。   
4/// </summary>

private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion
}
}

方法二:

DataGridPaging2.aspx

1@ Page language="c#" EnableViewState = "true" Codebehind="DataGridPaging2.aspx.cs" AutoEventWireup="false"   
2Inherits="eMeng.Exam.DataGridPaging2.DataGridPaging2" 
 1<html>
 2<head>
 3<title>功能齐全的分页的例子【2】</title>
 4<meta content="Visual Basic 7.0" name="CODE_LANGUAGE"/>
 5<meta content="JavaScript" name="vs_defaultClientScript"/>
 6<meta content=" http://schemas.microsoft.com/intellisense/ie5 " name="vs_targetSchema"/>
 7</head>
 8<body ms_positioning="GridLayout">
 9<form id="Form1" runat="server">
10<asp:datagrid allowpaging="True" alternatingitemstyle-backcolor="#eeeeee" autogeneratecolumns="False" bordercolor="black" borderwidth="1" cellpadding="3" cellspacing="0" font-name="Verdana" font-size="8pt" gridlines="Both" headerstyle-backcolor="#aaaadd" horizontalalign="Center" id="MyDataGrid" pagerstyle-horizontalalign="Right" pagerstyle-mode="NumericPages" pagesize="5" runat="server">
11<alternatingitemstyle backcolor="#EEEEEE"></alternatingitemstyle>
12<headerstyle backcolor="#AAAADD" font-bold="True" horizontalalign="Center"></headerstyle>
13<pagerstyle horizontalalign="Right" mode="NumericPages"></pagerstyle>
14<columns>
15<asp:boundcolumn datafield="Title" headerstyle-width="480px" headertext="标题"></asp:boundcolumn>
16<asp:boundcolumn datafield="CreateDate" dataformatstring="{0:yyyy-MM-dd hh:mm:ss}" headertext="发表日期"></asp:boundcolumn>
17</columns>
18</asp:datagrid>
19<p align="center">
20<asp:label font-bold="True" font-size="9pt" id="lblPageCount" runat="server"></asp:label>    
21<asp:label font-bold="True" font-size="9pt" id="lblCurrentIndex" runat="server"></asp:label>
22<asp:linkbutton commandargument="0" font-size="9pt" forecolor="navy" id="btnFirst" runat="server"></asp:linkbutton>    
23<asp:linkbutton commandargument="prev" font-size="9pt" forecolor="navy" id="btnPrev" runat="server"></asp:linkbutton>    
24<asp:linkbutton commandargument="next" font-size="9pt" forecolor="navy" id="btnNext" runat="server"></asp:linkbutton>    
25<asp:linkbutton commandargument="last" font-size="9pt" forecolor="navy" id="btnLast" runat="server"></asp:linkbutton>
26</p>
27</form>
28</body>
29</html>

DataGridPaging2.aspx.cs

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.DataGridPaging2
{
///

1<summary>   
2/// DataGridPaging 的摘要说明。   
3/// </summary>

public class DataGridPaging2 : 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="
+ HttpContext.Current.Server.MapPath("../../aspxWeb.mdb.ascx");
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();
}

#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}

///

1<summary>   
2/// 设计器支持所需的方法 - 不要使用代码编辑器修改   
3/// 此方法的内容。   
4/// </summary>

private void InitializeComponent()
{
this.MyDataGrid.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.OnPageIndexChanged);
this.btnFirst.Click += new System.EventHandler(this.PagerButtonClick);
this.btnPrev.Click += new System.EventHandler(this.PagerButtonClick);
this.btnNext.Click += new System.EventHandler(this.PagerButtonClick);
this.btnLast.Click += new System.EventHandler(this.PagerButtonClick);
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

private void OnPageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
int startIndex ;
startIndex = MyDataGrid.CurrentPageIndex * MyDataGrid.PageSize;
MyDataGrid.CurrentPageIndex = e.NewPageIndex;
BindGrid();
ShowStats();
}
}
}

Published At
Categories with Web编程
Tagged with
comments powered by Disqus