DataGrid分页优化-优快云博客

本文链接：https://blog.youkuaiyun.com/zgh2002007/article/details/1384013

本文介绍了一种在ASP.NET中优化DataGrid分页显示的方法，通过添加总记录数、总页数及当前页数增强用户体验。该方法适用于需要进行分页处理的应用场景。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

DataGrid终极分页法（四）：给分页加上总记录数、总页数、当前页数

原创

smallfools

2006-04-14 09:53:44

查看评论

如何给DataGrid加上总记录数、总页数、当前页数？如下图所示：

0 && image.height>0){if(image.width>=510){this.width=510;this.height=image.height*510/image.width;}}" border=0>

还是在DataGridPage.aspx.cs页面里，找到DataGrid1_ItemCreated事件，在这个事件的最后，加上以下代码：

Label la = new Label();
la.Text = "<table width=100%><tr><td align=left>总记录数：<b>"+ViewState["Row"].ToString()+" </b>";
la.Text += "总页数：<b>"+this.DataGrid1.PageCount+" </b>";
la.Text += "当前页：<font color=red><b>"+(this.DataGrid1.CurrentPageIndex+1).ToString()+" </b></font></td><td align=right>";
pager.Controls.AddAt(0,la);

Label lb = new Label();
lb.Text = "</td></tr></table>";
pager.Controls.Add(lb);

然后在DataGridBind()的“DataView dv = ds.Tables[0].DefaultView;”后加上一句“ViewState["Row"] = dv.Count;”

编译后看看效果吧。下列是完整的页面代码：

DataGridPage.aspx：

<%@ Page language="c#" Codebehind="DataGridPage.aspx.cs" AutoEventWireup="false" Inherits="test.DataGridPage" %>

<! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

< HTML >

<HEAD>

<title>DataGridPage</title>

<metaname="GENERATOR"Content="Microsoft Visual Studio .NET 7.1">

<metaname="CODE_LANGUAGE"Content="C#">

<metaname="vs_defaultClientScript"content="JavaScript">

<metaname="vs_targetSchema"content="http://schemas.microsoft.com/intellisense/ie5">

<styletype="text/css"> BODY { FONT-SIZE: 9pt; BACKGROUND-COLOR: #ffffff } A:visited { COLOR: #000000; TEXT-DECORATION: none } A:active { COLOR: #000000; TEXT-DECORATION: none } A:hover { LEFT: 1px; COLOR: #000000; POSITION: relative; TOP: 1px; TEXT-DECORATION: underline } A:link { COLOR: #000000; TEXT-DECORATION: none } TD { FONT-SIZE: 9pt;" 宋体" } </style>

</HEAD>

<body>

<formid="Form1"method="post"runat="server">

<FONTface=" 宋体">

<asp:DataGridid="DataGrid1"runat="server"AllowPaging="True">

<PagerStyleVerticalAlign="Middle"HorizontalAlign="Right"Mode="NumericPages"></PagerStyle>

</asp:DataGrid></FONT>

</form>

</body>

</ HTML >

DataGridPage.aspx.cs：

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

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.OleDb;

namespace test

{

///<summary>

/// DataGridPage 的摘要说明。

///</summary>

public class DataGridPage : System.Web.UI.Page

{

protected System.Web.UI.WebControls.DataGrid DataGrid1;

protected OleDbConnection conn = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=C://Program Files//Microsoft Office//OFFICE11//SAMPLES//Northwind.mdb");

private void Page_Load(object sender, System.EventArgs e)

{

if (!this.IsPostBack)

{

DataGridBind();

}

private void DataGridBind()

{

string strSql = "select * from 产品";

DataSet ds = new DataSet();

conn.Open();

OleDbDataAdapter myAdapter = new OleDbDataAdapter(strSql,conn);

myAdapter.Fill(ds,"ds");

conn.Close();

DataView dv = ds.Tables[0].DefaultView;

ViewState["Row"] = dv.Count;;

this.DataGrid1.DataSource = dv;

this.DataGrid1.DataBind();

}

#region Web 窗体设计器生成的代码

override protected void OnInit(EventArgs e)

{

// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。

InitializeComponent();

base.OnInit(e);

}

///<summary>

/// 设计器支持所需的方法 - 不要使用代码编辑器修改

/// 此方法的内容。

///</summary>

private void InitializeComponent()

{

this.DataGrid1.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemCreated);

this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged);

this.Load += new System.EventHandler(this.Page_Load);

}

#endregion

private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)

{

this.DataGrid1.CurrentPageIndex = e.NewPageIndex;

DataGridBind();

}

private void DataGrid1_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)

{

ListItemType elemType = e.Item.ItemType;

if (elemType == ListItemType.Pager)

{

TableCell pager = (TableCell)e.Item.Controls[0];

int up = 0;

int down = 0;

for (int i=0;i<pager.Controls.Count;i+=2)

{

Object o = pager.Controls[i];

if (o is LinkButton)

{

LinkButton h = (LinkButton) o;

if (h.Text!="...")

{

h.ToolTip = " 跳转到第"+h.Text+"页";

}

if (i==2)

{

up = int.Parse(h.Text)-1;

}

if (i==pager.Controls.Count-3)

{

down = int.Parse(h.Text)+1;

}

else

{

Label l = (Label) o;

if (i==2)

{

up = int.Parse(l.Text)-1;

}

if (i==pager.Controls.Count-3)

{

down = int.Parse(l.Text)+1;

}

l.Text = "["+l.Text+"]";

l.ForeColor = System.Drawing.Color.Red;

}

Object oo = pager.Controls[0];

if (oo is LinkButton)

{

LinkButton h = (LinkButton) oo;

if (h.Text=="...")

{

h.ToolTip = " 跳转到第"+up.ToString()+"页";

}

Object ooo = pager.Controls[pager.Controls.Count-1];

if (ooo is LinkButton)

{

LinkButton h = (LinkButton) ooo;

if (h.Text=="...")

{

h.ToolTip = " 跳转到第"+down.ToString()+"页";

}

Label la = new Label();

la.Text = "<table width=100%><tr><td align=left> 总记录数：<b>"+ViewState["Row"].ToString()+" </b>";

la.Text += " 总页数：<b>"+this.DataGrid1.PageCount+" </b>";

la.Text += " 当前页：<font color=red><b>"+(this.DataGrid1.CurrentPageIndex+1).ToString()+" </b></font></td><td align=right>";

pager.Controls.AddAt(0,la);

Label lb = new Label();

lb.Text = "</td></tr></table>";

pager.Controls.Add(lb);

}

标签: asp.net

票数：0

我顶

【发起辩论】 [手机订阅] [收藏到我的网摘]

[推荐] | [评论] | [投诉] | [打印]

本文章被推荐到了0个圈子
点击数: 264
评论数: 2

本文章引用通告地址(TrackBack Ping URL)为:

http://post.blog.hexun.com/smallfools/trackback.aspx?articleid=3146755
本文章尚未被引用。

分页4