微软的解决办法
ระบบการใช้งาน;
usingsystem.data;
usingsystem.data.sqlclient;
usingsystem.Drawing;
usingsystem.windows.forms;
publicclasspagingsample: แบบฟอร์ม
-
// FormControls
ButtonPrevbtn = newButton ();
buttonNextbtn = newButton ();
StaticDatAgridMyGrid = newDatagrid ();
StaticLabelPagelBl = newLabel ();
// PagingVariables
StaticIntPagesize = 10; // sizeofviewedPage
StaticIntTotAlpages = 0; // TotalPages
StaticIntCurrentPage = 0; // CurrentPage
StaticStringFirstVisiBleCustomer =; // FirstCustomerOnPagetodeTerminelocationFormovePrevious
StaticStringLastVisiBleCustomer =; // lastCustomerOnPagetOdetERMINELOCATIONFORMOVENEXT
// DatasetTobindTodatagrid
StaticDatatableCustTable;
// InitializeConnectionTodatabaseandDataadapter
StaticsQlConnectionNwindConn = newsQlConnection (dataSource = localHost; IntegratedSecurity = SSPI; initialCatalog = NorthWind);
staticsqldataadaptercustda = newsqldataadapter (, nwindconn);
StaticsQlCommandSelcmd = Custda.SelectCommand;
PublicStaticVoidGetData (StringDirection)
-
// createsqlstatementToreturnapageOfrecords
selcmd.parameters.clear ();
สวิตช์ (ทิศทาง)
-
Casenext:
selcmd.CommandText = selectTop+pagesize+customerId, companyNameFromCustomers+
wherecustomerid> @customeridorderbycustomerid;
selcmd.parameters.add (@customerId, sqldbtype.varchar, 5) .Value = lastVisiBleCustomer;
หยุดพัก;
caseprevious:
selcmd.CommandText = selectTop+pagesize+customerId, companyNameFromCustomers+
WherecustomerId <@customeridorderbycustomeriddesc;
selcmd.parameters.add (@customerId, sqldbtype.varchar, 5) .Value = FirstVisiBleCustomer;