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

来源：互联网发布：淘宝买的csgo 编辑：程序博客网时间：2024/05/21 09:15

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

查看更多精彩图片

还是在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>

</HEAD>

<body>

<asp:DataGrid id="DataGrid1" runat="server" AllowPaging="True">

</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);

}

Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1579739