Stored Procedure:
Getproductscount1:
Create procedure getproductscount1
Select count (*) from test
Go
Getproductsbypage:
Create procedure getproductsbypage
@ Pagenumber int,
@ Pagesize int
As
Declare @ SQL nvarchar (4000)
Set @ SQL = 'select top '+ convert (varchar, @ pagesize) +' * from test where id not in (select top '+ convert (varchar, (@ pagenumber-1) * @ pagesize) + 'id from test )'
Exec sp_executesql @ SQL
Go
Front-end code:
<% @ Page Language = "C #" autoeventwireup = "true" codefile = "default2.aspx. CS "inherits =" default2 "%> <br/> <% @ register Assembly =" aspnetpager "namespace =" Wuqi. webdiyer "tagprefix =" webdiyer "%> <br/> <% @ register Assembly =" system. web. extensions, version = 1.0.61025.0, culture = neutral, publickeytoken = 31bf3856ad364e35 "<br/> namespace =" system. web. ui "tagprefix =" asp "%> <br/> <! Doctype HTML public "-// W3C // dtd xhtml 1.0 transitional // en" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <br/> <HTML xmlns = "http://www.w3.org/1999/xhtml"> <br/> <pead runat = "server"> <br/> <title> No title page </title> <br/> <MCE: style type = "text/CSS"> <! -- <Br/>. lbtnstyle {<br/> font-size: 12px; color: black; text-Decoration: none; color: red; <br/>}< br/>. anpager. ECC {Background: #1f3a87 none repeat scroll 0 0; Border: 1px solid # cccccc; color: # ffffff; font-weight: bold; margin: 5px 4px 0 0 0; padding: 4px 5px 0; font-size: 12px} <br/>. anpager A {Background: # ffffff none repeat scroll 0 0; Border: 1px solid # cccccc; color: #1f3a87; margin: 5px 4px 0 0; padding: 4px 5px 0; text-Decoration: none; font-size: 12px} <br/>. anpager A: hover {Background: #1f3a87 none repeat scroll 0 0; Border: 1px solid #1f3a87; color: # ffffff ;} </P> <p> --> </MCE: style> <style type = "text/CSS" mce_bogus = "1">. lbtnstyle {<br/> font-size: 12px; color: black; text-Decoration: none; color: red; <br/>}< br/>. anpager. ECC {Background: #1f3a87 none repeat scroll 0 0; Border: 1px solid # cccccc; color: # ffffff; Font-weight: bold; margin: 5px 4px 0 0; padding: 4px 5px 0; font-size: 12px} <br/>. anpager A {Background: # ffffff none repeat scroll 0 0; Border: 1px solid # cccccc; color: #1f3a87; margin: 5px 4px 0 0; padding: 4px 5px 0; text-Decoration: none; font-size: 12px} <br/>. anpager A: hover {Background: #1f3a87 none repeat scroll 0 0; Border: 1px solid #1f3a87; color: # ffffff ;} <br/> </style> <br/> </pead> <br/> <body> <br/> <form Id = "form1" runat = "server"> <br/> <div> <br/> <asp: scriptmanager id = "scriptmanager1" runat = "server"> <br/> </ASP: scriptmanager> <br/> <asp: updatepanel id = "updatepanel1" runat = "server"> <br/> <contenttemplate> <br/> <Table> <br/> <tr> <br/> <TD width = "150"> <br/> <asp: textbox id = "txtname" runat = "server"> </ASP: textbox> <br/> </TD> <br/> <TD width = "300"> <br/> <asp: button id = "btninsert" runat = "Server "Text =" add row "/> <br/> </TD> <br/> </tr> <br/> <TD colspan = "2"> <br/> <asp: gridview id = "gridview1" runat = "server" autogeneratecolumns = "false" width = "pixel PX" cellpadding = "4" forecolor = "#333333" gridlines = "NONE" style =" font-size: 12px "mce_style =" font-size: 12px "onrowdatabound =" gridview1_rowdatabound1 "> <br/> <columns> <br/> <asp: templatefield> <br/> <peadertemplate> <br/> id <br/> </peadert Emplate> <br/> <edititemtemplate> <asp: textbox id = "txtid" runat = "server" text = '<% # eval ("ID ") %> 'enabled= "false"> </ASP: textbox> </edititemtemplate> <br/> <itemtemplate> <asp: label id = "labid" runat = "server" text = '<% # eval ("ID") %>'> </ASP: label> </itemtemplate> <br/> <controlstyle width = "170px"/> <br/> </ASP: templatefield> <br/> <asp: templatefield> <br/> <peadertemplate> <br/> name <br/> </peadertemplat E> <br/> <edititemtemplate> <asp: textbox id = "txtname" runat = "server" text = '<% # eval ("name ") %> '> </ASP: textbox> </edititemtemplate> <br/> <itemtemplate> <asp: label id = "labname" runat = "server" text = '<% # eval ("name") %>'> </ASP: label> </itemtemplate> <br/> <controlstyle width = "170px"/> <br/> </ASP: templatefield> <br/> <asp: templatefield> <br/> <edititemtemplate> <br/> <asp: linkbutton id = "lbtnupdt" runat = "Server" commandname = "Update" text = "Update" class = "lbtnstyle" onclientclick = "Return confirm ('Are you sure you want to update? '); "> </ASP: linkbutton> <br/> <asp: linkbutton id = "lbtncan" runat = "server" commandname = "cancel" text = "cancel" class = "lbtnstyle"> </ASP: linkbutton> <br/> </edititemtemplate> <br/> <itemtemplate> <br/> <asp: linkbutton id = "lbtnedit" commandname = "edit" runat = "server" text = "edit" class = "lbtnstyle"> </ASP: linkbutton> <br/> <asp: linkbutton id = "lbtndel" commandname = "delete" runat = "server" text = "delete" class = "lbtnstyle "Onclientclick =" Return confirm ('Are you sure you want to delete? '); "> </ASP: linkbutton> <br/> </itemtemplate> <br/> </ASP: templatefield> <br/> </columns> <br/> <footerstyle backcolor = "#507cd1" font-bold = "true" forecolor = "white"/> <br/> <rowstyle backcolor = "# eff3fb"/> <br/> <pagerstyle backcolor = "# 2461bf" forecolor = "white" horizontalalign = "center"/> <br/> <selectedrowstyle backcolor = "# d1ddf1" font-bold = "true" forecolor = "#333333"/> <br/> <peaderstyle backcolor = "#507cd1" font-bold = "true" forecolor = "white"/> <br/> <editrowstyle backcolor = "# 2461bf"/> <br/> <alternatingrowstyle backcolor = "white"/> <br/> </ ASP: gridview> <br/> </TD> <br/> </tr> <br/> <TD colspan = "2" align = "Right "> <br/> <webdiyer: aspnetpager id = "aspnetpager1" runat = "server" cssclass = "anpager" placement = "ECC" firstpagetext = "Homepage" lastpagetext = "last page" nextpagetext = "next page" prevpagetext =" previous Page "> <br/> </webdiyer: aspnetpager> <br/> </TD> <br/> </tr> <br/> </table> <br/> </contenttemplate> <br/> </ ASP: updatepanel> <br/> </div> <br/> </form> <br/> </body> <br/> </ptml> <br/>
Background code:
Private sqlconnection con; <br/> int currentpagenumber; // current page number <br/> int pagesize = 10; // number of records displayed per page <br/> protected void page_load (Object sender, eventargs e) <br/>{< br/> If (! Ispostback) <br/>{< br/> currentpagenumber = 1; <br/> viewstate ["currentpagenumber"] = currentpagenumber; <br/> getbind (); <br/>}< br/> // register the event <br/> gridview1.rowdeleting + = new Preview (gridview1_rowdeleting); <br/> gridview1.rowediting + = new Preview (gridview1_rowediting ); <br/> gridview1.rowupdating + = new Preview (gridview1_rowupdating); <br/> gridview1.rowcancelingedit + = new Preview (gridview1_rowcancelingedit); <br/> btninsert. click + = new eventhandler (btninsert_click); <br/> aspnetpager1.pagechanged + = new eventhandler (aspnetpager#pagechanged ); </P> <p >}< br/> // paging event <br/> void aspnetpager1_pagechanged (Object sender, eventargs E) <br/>{< br/> currentpagenumber = aspnetpager1.currentpageindex; <br/> viewstate ["currentpagenumber"] = currentpagenumber; <br/> getbind (); <br/>}< br/> // Add a data event <br/> void btninsert_click (Object sender, eventargs E) <br/> {<br/> string SQL = "insert into test (name) values ('" + txtname. text + "')"; <br/> con = new sqlconnection ("Server = .; database = jobwanted apartment; uid = sa; Pwd = "); <br/> sqlcommand cmd = new sqlcommand (SQL, con); <br/> con. open (); <br/> cmd. executenonquery (); <br/> getbind (); <br/>}< br/> // cancel the gridview editing <br/> void gridview#rowcancelingedit (Object sender, gridviewcancelediteventargs E) <br/>{</P> <p> gridview1.editindex =-1; <br/> getbind (); <br/>}< br/> // gridview modification event <br/> void gridview1_rowupdating (Object sender, gridviewupdateeventargs E) <br/> {<br/> string SQL = "Update Test Set Name = '" + (textbox) gridview1.rows [E. rowindex]. findcontrol ("txtname ")). text) + "'where id = '" + convert. toint32 (textbox) gridview1.rows [E. rowindex]. findcontrol ("txtid ")). text) + "'"; <br/> con = new sqlconnection ("Server = .; database = jobwanted apartment; uid = sa; Pwd = "); <br/> sqlcommand cmd = new sqlcommand (SQL, con); <br/> con. open (); <br/> cmd. executenonquery (); <br/> gridview1.editindex =-1; <br/> getbind (); <br/>}< br/> // gridview editing event <br/> void gridview1_rowediting (Object sender, gridviewediteventargs e) <br/>{< br/> gridview1.editindex = E. neweditindex; <br/> getbind (); <br/>}< br/> // The row deletion event in the gridview <br/> void gridview1_rowdeleting (Object sender, gridviewdeleteeventargs E) <br/> {<br/> string SQL = "delete from test where id = '" + convert. toint32 (Label) gridview1.rows [E. rowindex]. findcontrol ("labid ")). text) + "'"; <br/> con = new sqlconnection ("Server = .; database = jobwanted apartment; uid = sa; Pwd = "); <br/> sqlcommand cmd = new sqlcommand (SQL, con); <br/> con. open (); <br/> cmd. executenonquery (); <br/> getbind (); <br/>}< br/> // gridview Data Binding <br/> private void getbind () <br/> {<br/> currentpagenumber = convert. toint32 (viewstate ["currentpagenumber"]); <br/> con = new sqlconnection ("Server = .; database = jobwanted apartment; uid = sa; Pwd = "); <br/> sqlcommand cmd = new sqlcommand (" getproductscount1 ", con); <br/> cmd. commandtype = commandtype. storedprocedure; <br/> sqlcommand cmd1 = new sqlcommand ("getproductsbypage", con); <br/> export 1.commandtype = commandtype. storedprocedure; <br/> parameters 1.parameters. add ("@ pagenumber", sqldbtype. int, 4 ). value = currentpagenumber; <br/> parameters 1.parameters. add ("@ pagesize", sqldbtype. int, 4 ). value = pagesize; <br/> con. open (); <br/> datatable dt = new datatable (); <br/> sqldataadapter adapter = new sqldataadapter (cmd1); <br/> adapter. fill (DT); <br/> // aspnetpager1.pagesize = 10; // set the number of lines displayed on each page <br/> aspnetpager1.recordcount = (INT) cmd. executescalar (); // obtain the total number of records <br/> aspnetpager1.currentpageindex = currentpagenumber; <br/> gridview1.datasource = DT; <br/> gridview1.databind (); <br/>}< br/> // display the highlighted row in the gridview <br/> protected void gridview1_rowdatabound1 (Object sender, gridviewroweventargs E) <br/>{< br/> If (E. row. rowtype = datacontrolrowtype. datarow) <br/>{< br/> E. row. attributes. add ("onmouseover", "c = This. style. backgroundcolor, this. style. backgroundcolor = '# c7def3' "); <br/> E. row. attributes. add ("onmouseout", "this. style. backgroundcolor = C "); <br/>}< br/>}
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
