一个功能齐全的DataGrid分页例子

最新推荐文章于 2025-12-21 22:09:29 发布

转载最新推荐文章于 2025-12-21 22:09:29 发布 · 725 阅读

文章标签：

#datagrid #asp #dataset #server #object #html

ASP.NET 专栏收录该内容

10 篇文章

订阅专栏

本文介绍了一个使用ASP.NET DataGrid实现分页功能的例子，通过设置属性允许用户进行页面跳转并展示每页5条记录。文章包含完整的ASPX及C#后台代码。

下面的这个例子提供了DataGrid的分页功能。ASPx代码和Cohe Behind代码分别如下，注意更改数据录连接字符串。结果如下：

C#版本 例子

DataGridPaging.aspx

<%@ 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="<a href="http://dev.21tx.com/web/javascript/" target="_blank">JavaScript</a>" 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>

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
{
/// &amp;lt;summary&amp;gt;
/// DataGridPaging 的摘要说明。
/// &amp;lt;/summary&amp;gt;
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 = &amp;quot;最首页&amp;quot;;
btnPrev.Text = &amp;quot;前一页&amp;quot;;
btnNext.Text = &amp;quot;下一页&amp;quot;;
btnLast.Text = &amp;quot;最后页&amp;quot;;
OpenDatabase();
BindGrid();
}
private void OpenDatabase()
{
cn.ConnectionString = &amp;quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&amp;quot; + Server.MapPath(&amp;quot;xxxx.mdb&amp;quot;);
cn.Open();
}
private void ShowStats()
{
lblCurrentIndex.Text = &amp;quot;第 &amp;quot; + (MyDataGrid.CurrentPageIndex + 1).ToString() + &amp;quot; 页&amp;quot;;
lblPageCount.Text = &amp;quot;总共 &amp;quot; + MyDataGrid.PageCount.ToString() + &amp;quot; 页&amp;quot;;
}
public void PagerButtonClick(object sender, EventArgs e)
{
string arg = ((LinkButton)sender).CommandArgument.ToString();
switch(arg)
{
case &amp;quot;next&amp;quot;:
if (MyDataGrid.CurrentPageIndex &amp;lt; (MyDataGrid.PageCount - 1))
{
MyDataGrid.CurrentPageIndex += 1;
}
break;
case &amp;quot;prev&amp;quot;:
if (MyDataGrid.CurrentPageIndex &amp;gt; 0)
{
MyDataGrid.CurrentPageIndex -= 1;
}
break;
case &amp;quot;last&amp;quot;:
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(&amp;quot;Select Title,CreateDate from Document&amp;quot;, myConnection);
adapter.Fill(ds, &amp;quot;Document&amp;quot;);
MyDataGrid.DataSource = ds.Tables[&amp;quot;Document&amp;quot;].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);
}
/// &amp;lt;summary&amp;gt;
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// &amp;lt;/summary&amp;gt;
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}