DataGrid Connect ACCESS Express Pipement Law (5) - Implement Fast Page
I use the "Order Detail" table of the Northwind Chinese database that comes with Access, but I added a field named "ID" in this table, and the data type is "Auto Number" and name the table "order. list".
FastPaging_Dataset.aspx
-------------------------------------------------- ------------------------------------
<% @ Page language = "c #" Codebehind = "FastPaging_DataSet.aspx.cs" AutoEventWireup = "false" Inherits = "Paging.FastPaging_DataSet" EnableSessionState = "False" enableViewState = "True" enableViewStateMac = "False"%>
DataGrid DataReader Custom Points </ Title></p>
<p><meta content = "Microsoft Visual Studio .NET 7.1" Name = "Generator"></p>
<p><meta content = "c #" Name = "code_language"></p>
<p><meta content = "javascript" name = "vs_defaultclientscript"></p>
<p><meta content = "http://schemas.microsoft.com/intellisense/ie5" Name = "vs_targetschema"></p>
<p></ HEAD></p>
<p><body></p>
<p><form runat = "server"></p>
<p><ask: DataGrid ID = "DATAGRID1" runat = "server" borderwidth = "1px" bordercolor = "black" font-size = "12pt"</p>
<p>AlternatingItemStyle-backcolor = "# eeeeee" Headersty-backcolor = "# aaaadd" Pagerstyle-Horizontalalign = "Right"</p>
<p>Cellpadding = "3" allowpaging = "true" allowcustompaging = "true" autogeneratecolumns = "false" onpageIndexchanged = "myDataGrid_page"</p>
<p>PageSize = "15" allowsorting = "true" OnsortCommand = "DataGrid1_sortCommand"> <AlternatingItemStyle Backcolor = "# eeeeee"> </ alternatingItemStyle></p>
<p><ItemStyle font-size = "smaller" borderwidth = "22px"> </ itemStyle></p>
<p><Headerstyle BackColor = "# aaaadd"> </ headerstyle></p>
<p><Columns></p>
<p><asp: boundcolumn datafield = "id" sortexpression = "id" Headertext = "id"> </ asp: boundcolumn></p>
<p><asp: boundcolumn datafield = "Order ID" Headertext = "Order ID"> </ asp: boundcolumn></p>
<p><asp: boundcolumn datafield = "Product ID" Headertext = "Product ID"> </ asp: boundcolumn></p>
<p><ask: boundcolumn datafield = "unit price" Headertext = "unit price"> </ asp: boundcolumn></p>
<p><asp: boundcolumn datafield = "Quantity" Headertext = "Quantity"> </ asp: boundcolumn></p>
<p><asp: boundcolumn datafield = "Discount" Headeertext = "Discount"> </ asp: boundcolumn></p>
<p></ Columns></p>
<p><PagersTyle font-name = "verdana" font-bold = "true" horizontalalign = "right" forcolor = "coORAL"</p>
<p>Mode = "numericpages"> </ pageerstyle></p>
<p></ asp: datagrid> </ form></p>
<p></ body></p>
<p></ Html></p>
<p>FastPaging_dataset.aspx.cs</p>
<p>-------------------------------------------------- ------------------------------------</p>
<p>Using system;</p>
<p>Using system.collections;</p>
<p>Using system.componentmodel;</p>
<p>Using system.data;</p>
<p>Using system.drawing;</p>
<p>Using system.Web;</p>
<p>Using system.Web.SessionState;</p>
<p>Using system.Web.ui;</p>
<p>Using system.Web.ui.webcontrols;</p>
<p>Using system.Web.ui.htmlcontrols;</p>
<p>Using system.data.oledb;</p>
<p>Using System.Text; Namespace Paging</p>
<p>{</p>
<p>Public class fastpaging_dataset: system.web.ui.page</p>
<p>{</p>
<p>Protected system.web.ui.webcontrols.dataGrid DataGrid1;</p>
<p>Const string query_fields = "*"; // to query the field</p>
<p>const string Table_name = "Order Ming Fine Table"; // Data Sheet Name</p>
<p>Const string primary_key = "id"; // primary key field</p>
<p>const string def_order_type = "ASC"; // Default Sort by</p>
<p>Const string sec_order_type = "dec"; // Optional sorting method</p>
<p>Const string condition = "Product ID = 'AV-CB-1'";</p>
<p>OLEDBCONNECTION CONN;</p>
<p>OLEDBCOMMAND CMD;</p>
<p>OLEDBDataAdapter DA;</p>
<p>#region attribute</p>
<p>#Region CurrentPageIndex</p>
<p>/// <summary></p>
<p>/// Get or set the index of the current page.</p>
<p>/// </ summary></p>
<p>Public Int CurrentPageIndex</p>
<p>{</p>
<p>Get {return (int) ViewState ["currentpageindex"];</p>
<p>Set {ViewState ["CurrentPageIndex"] = Value;</p>
<p>}</p>
<p>#ndregion</p>
<p>#Region Ordertype</p>
<p>/// <summary></p>
<p>/// Get sorted mode: Ascending order (ASC) or descending (DESC).</p>
<p>/// </ summary></p>
<p>Public String Ordetepe</p>
<p>{</p>
<p>Get {</p>
<p>String ORDERTYPE = DEF_ORDER_TYPE;</p>
<p>IF (ViewState ["Ordertype"]! = NULL) {</p>
<p>ORDERTYPE = (String) ViewState ["Ordertype"];</p>
<p>IF (ORDERTYPE! = sec_order_type)</p>
<p>ORDERTYPE = DEF_ORDER_TYPE;</p>
<p>}</p>
<p>Return Ordertype;</p>
<p>}</p>
<p>Set {ViewState ["Ordertype"] = value.toupper ();}</p>
<p>}</p>
<p>#ndregion</p>
<p>#ndregion</p>
<p>Private Void Page_Load (Object Sender, System.EventArgs E)</p>
<p>{</p>
<p>#Region implementation</p>
<p>String strconn = "provider = microsoft.jet.Oledb.4.0; data source ="</p>
<p> Server.mappath ("Northwind.mdb");</p>
<p>CONN = New OLEDBCONNECTION (STRCONN);</p>
<p>CMD = New OLEDBCOMMAND (", CONN);</p>
<p>Da = New OLEDBDataAdapter (CMD);</p>
<p>IF (! ispostback) {</p>
<p>// Set the total number of records used to automatically calculate the page DataGrid1.virtualItemcount = getRecordcount (Table_name);</p>
<p>CurrentPageIndex = 0;</p>
<p>BinddataGrid ();</p>
<p>}</p>
<p>#ndregion</p>
<p>}</p>
<p>#Region web form designer generated code</p>
<p>Override protected void oninit (Eventargs E)</p>
<p>{</p>
<p>//</p>
<p>// Codegen: This call is necessary for the ASP.NET Web Form Designer.</p>
<p>//</p>
<p>InitializationComponent ();</p>
<p>Base.onit (E);</p>
<p>}</p>
<p>/// <summary></p>
<p>/// Designer supports the required method - do not use the code editor to modify</p>
<p>/// This method is content.</p>
<p>/// </ summary></p>
<p>Private vidinitiRizeComponent ()</p>
<p>{</p>
<p>This.Load = New System.EventHandler (this.page_load);</p>
<p>}</p>
<p>#ndregion</p>
<p>Private void binddatagrid ()</p>
<p>{</p>
<p>#Region implementation</p>
<p>/ / Set the index of the current page</p>
<p>DataGrid1.currentpageIndex = CurrentPageIndex;</p>
<p>// Set the data source</p>
<p>DataGrid1.datasource = getDataView ();</p>
<p>DataGrid1.databind ();</p>
<p>#ndregion</p>
<p>}</p>
<p>/// <summary></p>
<p>/// Total the total number of records in the database table.</p>
<p>/// </ summary></p>
<p>/// <param name = "TableName"> The name of the table in the database. </ param></p>
<p>/// <returns> success is the total number of records in the table; otherwise be -1. </ returns></p>
<p>Private int getRecordcount (String Tablename)</p>
<p>{</p>
<p>#Region implementation</p>
<p>INT country;</p>
<p>CMD.comMandtext = "Select count (*) as recordcount from" TABLENAME;</p>
<p>Try {</p>
<p>Cn.open ();</p>
<p>Count = Convert.Toint32 (cmd.executescalar ());</p>
<p>} catch (exception ex) {</p>
<p>Response.write (ex.Message.toString ());</p>
<p>count = -1;</p>
<p>} finally {</p>
<p>CONN.CLOSE ();</p>
<p>}</p>
<p>Return count;</p>
<p>#ndregion</p>
<p>}</p>
<p>Private dataView getDataView ()</p>
<p>{</p>
<p>#Region implementation</p>
<p>INT Pagesize = DataGrid1.pageSize;</p>
<p>DataSet DS = New DataSet ();</p>
<p>DataView DV = NULL;</p>
<p>cmd.comMandtext = fastpaging.paging (</p>
<p>PageSize,</p>
<p>CurrentPageIndex,</p>
<p>DataGrid1.virtualItemcount,</p>
<p>Table_name,</p>
<p>Query_fields,</p>
<p>PRIMARY_KEY,</p>
<p>FastPaging.Isascending (Ordertype));</p>
<p>Try {</p>
<p>Da.fill (DS, Table_name);</p>
<p>DV = ds.tables [0] .defaultView;</p>
<p>} catch (exception ex) {</p>
<p>Response.write (ex.Message.toString ());</p>
<p>}</p>
<p>Return DV; #ndregion</p>
<p>}</p>
<p>Protected void myDataGrid_page (Object Sender, DataGridPageChangeDeventargs E)</p>
<p>{</p>
<p>CurrentPageIndex = E.NewpageIndex;</p>
<p>BinddataGrid ();</p>
<p>}</p>
<p>Protected void DataGrid1_sortcommand (Object Source, DataGridSortCommandeventEventArgs E)</p>
<p>{</p>
<p>#Region implementation</p>
<p>DataGrid1.currentpageIndex = 0;</p>
<p>THIS.CURRENTPAGEINDEX = 0;</p>
<p>IF (Ordertype == Def_ORDER_TYPE)</p>
<p>ORDERTYPE = SEC_ORDER_TYPE;</p>
<p>Else</p>
<p>ORDERTYPE = DEF_ORDER_TYPE;</p>
<p>BinddataGrid ();</p>
<p>#ndregion</p>
<p>}</p>
<p>}</p>
<p>}</p>
<p>I have to introduce the DataGrid connection ACCESS's fast paging method here. If you have other better paging methods, it is better to share it with you!</p>
<p>The younger brother wrote the article for the first time, there is something wrong, I hope everyone will correct.</p>
<p>Author: Tripoli</p>
<p>Mailbox: itfun@163.com</p></div><div class="text-center mt-3 text-grey">
转载请注明原文地址:https://www.9cbs.com/read-25911.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="25911" 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.048</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 = 'sAvtBUvjlOAHvHJ68TPUWt74rPFFftVWyAEJAzvA375r5t_2BR_2FbAMZV5jYYZ4WKr3k0NZe4L6jKkdtcIHCyb0Mw_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>
