本文主要是介绍Eric的超高效数据分页(图示+代码) ^_^，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
运行截图:
数据表结构:
megaid int IDENTITY (1, 1) NOT NULL PRIMARY KEY CLUSTERED
megaguid char (36) NOT NULL INDEX
数据生成脚本:
数据表结构:
megaid int IDENTITY (1, 1) NOT NULL PRIMARY KEY CLUSTERED
megaguid char (36) NOT NULL INDEX
数据生成脚本:
DECLARE @i int SET @i = 1 WHILE @i < 1000001 BEGIN INSERT INTO megatable (megaguid) VALUES ( NEWID ()) SET @i = @i + 1 END GO C#代码:
DateTime startTime; void Page_Init(Object sender, EventArgs e)
{
startTime = DateTime.Now;
} protected override void Render(HtmlTextWriter writer) { base.Render(writer); Response.Write("本页执行时间: " + (DateTime.Now - startTime)); } int records = 10000 ; int pages = 10 ; int pageSize = 15 ; SqlConnection conn = new SqlConnection( " Server=(local);Database=megadata;User Id=sa;Password=xxx " ); void Page_Load( object sender, EventArgs e) { if (!IsPostBack)
{ dgBind(getSqlString(1));
} int firstPage = int.Parse(hidFirstPage.Value); pnlButtons.Controls.Add(getPager(firstPage)); lblPrompt.Text = "数据提取范围: <B>SELECT TOP " + records.ToString() + " megaid FROM megatable ORDER BY megaguid</B>"; } string getSqlString( int selectedPage) { string[] idsStrArray; string sqlStr; if (Session["idStr"] != null) { idsStrArray = Session["idStr"].ToString().Split('#'); } else { sqlStr = "SELECT TOP " + records.ToString() + " megaid FROM megatable ORDER BY megaguid"; SqlCommand cmd = new SqlCommand(sqlStr, conn); conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); StringBuilder sb = new StringBuilder(""); int n = 1; while (dr.Read()) { if (n % pageSize == 0) { sb.Append(dr[0].ToString() + "#"); } else { sb.Append(dr[0].ToString() + ","); } n++; } dr.Close(); conn.Close(); sb.Remove(sb.Length - 1, 1); idsStrArray = sb.ToString().Split('#'); Session["idStr"] = sb.ToString(); } hidPageCount.Value = idsStrArray.Length.ToString(); sqlStr = "SELECT megaid, megaguid FROM megatable WHERE megaid IN (" + idsStrArray[selectedPage - 1] + ") "; sqlStr += "ORDER BY megaguid"; return sqlStr; } Panel getPager( int firstPage) { int pageCount = int.Parse(hidPageCount.Value); Panel pnlPager = new Panel(); pnlPager.Controls.Add(new LiteralControl("<BR> 共" + pageCount.ToString() + "页 ")); pnlPager.Controls.Add(getLinkButton("Fst", "首页", "pgBtn", "1")); pnlPager.Controls.Add(new LiteralControl(" ")); if (firstPage > 0) { pnlPager.Controls.Add(getLinkButton("Pre", "前" + pages.ToString() + "页", "pgBtn", (firstPage - pages + 1).ToString())); pnlPager.Controls.Add(new LiteralControl(" ")); } for (int i = firstPage + 1; i < firstPage + pages + 1; i++) { if (i > pageCount) { break; } pnlPager.Controls.Add(getLinkButton(i.ToString(), "[" + i.ToString() + "]", "pgBtn", i.ToString())); pnlPager.Controls.Add(new LiteralControl(" ")); } if (firstPage + pages < pageCount) { pnlPager.Controls.Add(getLinkButton("Nxt", "后" + pages.ToString() + "页", "pgBtn", (firstPage + pages + 1).ToString())); pnlPager.Controls.Add(new LiteralControl(" ")); } pnlPager.Controls.Add(getLinkButton("Lst", "末页", "pgBtn", pageCount.ToString())); return pnlPager; } LinkButton getLinkButton( string lbId, string lbText, string lbCmdName, string lbCmdArg) { LinkButton lb = new LinkButton(); lb.ID = lbCmdName + lbId; lb.Text = lbText; lb.CommandName = lbCmdName; lb.CommandArgument = lbCmdArg; lb.Command += new CommandEventHandler(pageTurn); return lb; } void pageTurn( object sender, CommandEventArgs e) { LinkButton lb = (LinkButton)sender; int selectedPage = int.Parse(lb.CommandArgument); int firstPage = selectedPage / pages * pages; firstPage = (selectedPage % pages == 0) ? (firstPage - pages) : firstPage; hidFirstPage.Value = firstPage.ToString(); dgBind(getSqlString(selectedPage)); pnlButtons.Controls.RemoveAt(pnlButtons.Controls.Count - 1); pnlButtons.Controls.Add(getPager(firstPage)); lb = (LinkButton)pnlButtons.Controls[pnlButtons.Controls.Count - 1].FindControl("pgBtn" + selectedPage.ToString()); lb.Enabled = false; } void dgBind( string sqlStr) { SqlDataAdapter da = new SqlDataAdapter(sqlStr, conn); DataTable dt = new DataTable(); conn.Open(); da.Fill(dt); conn.Close(); da.Dispose(); dg.DataSource = dt; dg.DataBind(); } void dg_ItemDataBound( object sender, DataGridItemEventArgs e) { dg.Controls[0].EnableViewState = false; } ASPX代码:
<% @ Import Namespace="System.Text" %> <% @ Import Namespace="System.Data.SqlClient" %> <% @ Import Namespace="System.Data" %> <% @ Page Language="C#" %> <! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd" > < HTML > < HEAD > < TITLE > Pager </ TITLE > < SCRIPT runat ="server" > //插入上面的C#代码 </ SCRIPT > < STYLE > BODY {}{ FONT-SIZE: 9pt; FONT-FAMILY: Tahoma,宋体; TEXT-ALIGN: center } TD {}{ FONT-SIZE: 9pt; FONT-FAMILY: Tahoma,宋体; TEXT-ALIGN: center } </ STYLE > </ HEAD > < BODY > < FORM id ="form1" runat ="server" > < DIV > < ASP:LABEL id ="lblPrompt" runat ="server" text ="?" enableviewstate ="False" enabletheming ="True" ></ ASP:LABEL > < BR > < ASP:PANEL id ="pnlButtons" runat ="server" width ="560px" > < INPUT id ="hidFirstPage" type ="hidden" value ="0" runat ="server" >< INPUT id ="hidPageCount" type ="hidden" runat ="server" > < ASP:DATAGRID id ="dg" runat ="server" width ="100%" onitemdatabound ="dg_ItemDataBound" cellpadding ="4" backcolor ="White" borderwidth ="1px" borderstyle ="None" bordercolor ="#CC9966" autogeneratecolumns ="False" pagesize ="5" > < FOOTERSTYLE forecolor ="#330099" backcolor ="#FFFFCC" ></ FOOTERSTYLE > < HEADERSTYLE font-bold ="True" forecolor ="#FFFFCC" backcolor ="#990000" ></ HEADERSTYLE > < PAGERSTYLE horizontalalign ="Center" forecolor ="#330099" backcolor ="#FFFFCC" ></ PAGERSTYLE > < SELECTEDITEMSTYLE font-bold ="True" forecolor ="#663399" backcolor ="#FFCC66" ></ SELECTEDITEMSTYLE > < ITEMSTYLE forecolor ="#330099" backcolor ="White" ></ ITEMSTYLE > < COLUMNS > < ASP:BOUNDCOLUMN datafield ="megaid" headertext ="MegaID" ></ ASP:BOUNDCOLUMN > < ASP:BOUNDCOLUMN datafield ="megaguid" headertext ="MegaGUID" ></ ASP:BOUNDCOLUMN > </ COLUMNS > </ ASP:DATAGRID > </ ASP:PANEL ></ DIV > < BR > < ASP:HYPERLINK id ="lnkReload" runat ="server" width ="80px" navigateurl ="Pager.aspx" enableviewstate ="False" > 重载 </ ASP:HYPERLINK > </ FORM > </ BODY > </ HTML > 这篇关于Eric的超高效数据分页(图示+代码) ^_^的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
