Run screenshot:
Data Sheet Structure: Megaid Int IDENTITY (1, 1) Not Null Primary Key Clustered MegaGuid Char (36) Not Null Index
Data generating script:
Declare @i int set @i = 1 while @i <1000001 begin insert @i <1000001 begin insert inTo megatable (megaGuid) Values (newid ()) set @i = @i 1 End Go
C # code:
DateTime StartTime; Void Page_init (Object Sender, Eventargs E) {StartTime = DateTime.now;}
Protected Override Void Render (HTMLTextWriter Writer) {base.render (Writer); response.write ("This page execution time:" (DateTime.now - starttime));}
INT Records = 10000; int Pages = 10; int Pagesize = 15; sqlconnection conn = new SqlConnection ("Server = (local); data = 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 = "data extraction range: SELECT TOP" records.ToString () "megaid FROM megatable Order by megaguid ";
String getsqlstring (int selectedPage) {string [] idsstray; 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 ( "
co" pageCount. ToString () "Page")); PNLPager.Controls.Add (GetLinkButton ("FST", "Home", "PGBTN", "1")); PNLPager.Controls.Add (New LitralControl (")); IF (FirstPage> 0) {pnlpager.controls.add (GetLinkButton ("pre", "front" pages.tostring () "page", "pgbtn", (firstpage - pages 1) .tostring ())) PnlPager.Controls.add (New LiteralControl ("));} for (int i = firstpage 1; i pagecount) {Break;} pnlpager.controls. Add (GetLinkButton .Tostring (), "[" i.to.TRING () "]", "pgbtn", i.totring ()); pnlpager.controls.add (new literalcontrol ("));} if (FirstPage Pages
, 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 = NE W 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 Code: <% @ Import Namespace = "System.Text"%> <% @ Import Namespace = "System.Data.SqlClient "%> <% @ Import namespace =" system.data "%> <% @ page language =" c # "%>
Pager </ title> <script runat =" server "> // Insert the top C # code </ script > <Style> body {} {font-size: 9pt; font-family: tahoma, Song; Text-align: center} TD {} {font-size: 9pt; font-family: Tahoma, Song; Text-align: Center} </ style> </ head> <body> <form id = "form1" runat = "server"> <div> <ask: label id = "lblprompt" runat = "server" text = "" enableViewState = "False" enabletheming = "true"> </ asp: label> <br> <asp: panel id = "pnlbuttons" runat = "server" width = "560px"> <input = "hidfirstpage" type = "hidden" Value = "0" runat = "server"> <input = "hidpagecount" type = "hidden" runat = "server"> <asp: datagrid id = "DG" runat = "s ERVER "width =" 100% "onItemDatabase =" DG_ItemDatabase "cellpadding =" 4 "backcolor =" white "borderwidth =" 1px "borderwidth =" none "bordercolor =" # cc9966 "autogeneratecolumns =" false "</p></div><div class="text-center mt-3 text-grey">
转载请注明原文地址:https://www.9cbs.com/read-81654.html</div><div class="plugin d-flex justify-content-center mt-3"></div><hr><div class="row"><div class="col-lg-12 text-muted mt-2"><i class="icon-tags mr-2"></i><span class="badge border border-secondary mr-2"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></span></div></div></div></div><div class="card card-postlist border-white shadow"><div class="card-body"><div class="card-title"><div class="d-flex justify-content-between"><div><b>New Post</b>(<span class="posts">0</span>)
</div><div></div></div></div><ul class="postlist list-unstyled">
</ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="81654" checked /></div></div></div></div></div><footer class="text-muted small bg-dark py-4 mt-3" id="footer"><div class="container"><div class="row"><div class="col">CopyRight © 2020 All Rights Reserved
</div><div class="col text-right">Processed:
<b>0.041</b>, SQL:
<b>9</b></div></div></div></footer><script src="./lang/en-us/lang.js?2.2.0"></script><script src="view/js/jquery.min.js?2.2.0"></script><script src="view/js/popper.min.js?2.2.0"></script><script src="view/js/bootstrap.min.js?2.2.0"></script><script src="view/js/xiuno.js?2.2.0"></script><script src="view/js/bootstrap-plugin.js?2.2.0"></script><script src="view/js/async.min.js?2.2.0"></script><script src="view/js/form.js?2.2.0"></script><script>
var debug = DEBUG = 0;
var url_rewrite_on = 1;
var url_path = './';
var forumarr = {"1":"Tech"};
var fid = 1;
var uid = 0;
var gid = 0;
xn.options.water_image_url = 'view/img/water-small.png';
</script><script src="view/js/wellcms.js?2.2.0"></script><a class="scroll-to-top rounded" href="javascript:void(0);"><i class="icon-angle-up"></i></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"><i class="icon-angle-down"></i></a></body></html><script>
var forum_url = 'list-1.html';
var safe_token = '8mlRAdcIRYHCHO6BnhFvcf3_2FJyzxoVZuVAvjG2BsrnsT0ymCnCQW7yGagv4TUNxrdsKXA38uc6S3MafLkQoemg_3D_3D';
var body = $('body');
body.on('submit', '#form', function() {
var jthis = $(this);
var jsubmit = jthis.find('#submit');
jthis.reset();
jsubmit.button('loading');
var postdata = jthis.serializeObject();
$.xpost(jthis.attr('action'), postdata, function(code, message) {
if(code == 0) {
location.reload();
} else {
$.alert(message);
jsubmit.button('reset');
}
});
return false;
});
function resize_image() {
var jmessagelist = $('div.message');
var first_width = jmessagelist.width();
jmessagelist.each(function() {
var jdiv = $(this);
var maxwidth = jdiv.attr('isfirst') ? first_width : jdiv.width();
var jmessage_width = Math.min(jdiv.width(), maxwidth);
jdiv.find('img, embed, iframe, video').each(function() {
var jimg = $(this);
var img_width = this.org_width;
var img_height = this.org_height;
if(!img_width) {
var img_width = jimg.attr('width');
var img_height = jimg.attr('height');
this.org_width = img_width;
this.org_height = img_height;
}
if(img_width > jmessage_width) {
if(this.tagName == 'IMG') {
jimg.width(jmessage_width);
jimg.css('height', 'auto');
jimg.css('cursor', 'pointer');
jimg.on('click', function() {
});
} else {
jimg.width(jmessage_width);
var height = (img_height / img_width) * jimg.width();
jimg.height(height);
}
}
});
});
}
function resize_table() {
$('div.message').each(function() {
var jdiv = $(this);
jdiv.find('table').addClass('table').wrap('<div class="table-responsive"></div>');
});
}
$(function() {
resize_image();
resize_table();
$(window).on('resize', resize_image);
});
var jmessage = $('#message');
jmessage.on('focus', function() {if(jmessage.t) { clearTimeout(jmessage.t); jmessage.t = null; } jmessage.css('height', '6rem'); });
jmessage.on('blur', function() {jmessage.t = setTimeout(function() { jmessage.css('height', '2.5rem');}, 1000); });
$('#nav li[data-active="fid-1"]').addClass('active');
</script>
