Home > Others

Use the paging function in the repeater and datalist controls

Source: Internet
Author: User
Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞
The repeater and datalist controls can quickly and flexibly display data on the. ASPX page,
Neither of them has the paging function. Although the DataGrid Control has the paging function, it is too flexible to use.
Many articles are discussing the paging functions of repeater and datalist. We will use
The pagedatasource class is paginated in repeater:
Pagedatasource is a class encapsulated in the DataGrid, which is used to implement the paging function;
You can also use this class to pagination in datalist and repeater.
The problem can be solved.

<% @ Import namespace = "system. Data" %>
<% @ Import namespace = "system. Data. sqlclient" %>
<HTML>
<Head>
<Title> default </title>
<Meta http-equiv = "Content-Type" content = "text/html; charset = gb2312">
<Script language = "C #" runat = "server">
Public void page_load (Object SRC, eventargs E)
{Sqlconnection CNN = new sqlconnection ("Server = zzl; uid = sa; Pwd = 970480; database = zzl"); // connect to the database
Sqldataadapter mycommand = new sqldataadapter ("select * From start1", CNN); // data operations are performed on the start1 table and its data in sqlserver.
Dataset DS = new dataset ();
Mycommand. Fill (DS); // The DataSet object of the instance is DS, and the data is filled to DS.

Pageddatasource pp = new pageddatasource (); // class instance object of the paging Function
Pp. datasource = Ds. Tables [0]. defaultview; // assign data to the object PP
Pp. allowpaging = true; // pagination allowed
Pp. pagesize = 6; // set the number of data entries per page
Int cpage; // The integer used to analyze the number of pages
If (request. querystring ["page"]! = NULL) // This judgment statement is used to assign values to the cpage.
Cpage = convert. toint32 (request. querystring ["page"]);
Else
Cpage = 1;
Pp. currentpageindex = cpage-1; // The current index value of the PP object, because the index value starts from 0 and cpage starts from 1.
If (! Pp. isfirstpage) // request. currentexecutionfilepath is the file name of the current program, which can be directly written.
Pre. navigateurl = request. currentexecutionfilepath + "? Page = "+ convert. tostring (cpage-1 );

If (! Pp. islastpage)
Next. navigateurl = request. currentexecutionfilepath + "? Page = "+ convert. tostring (cpage + 1 );

Repeater1.datasource = pp;
Repeater1.databind ();}
</SCRIPT>
</Head>
<Body>
<Table width = "100%" border = "0">
<Tr> <TD> & nbsp; <asp: Label id = "current" runat = "server"/> </TD> </tr>
<Tr> <TD> & nbsp; <asp: hyperlink id = "pre" runat = "server"> </ASP: hyperlink>
<Asp: hyperlink id = "Next" runat = "server"> </ASP: hyperlink> </TD> </tr> </table>
<Asp: repeater id = "repeater1" runat = "server">
<Itemtemplate>
<Table width = "100%" border = "0">
<Tr> <TD> & nbsp; <% # databinder. eval (container. dataitem, "product") %> </TD> </tr>
<Tr> <TD> & nbsp; </TD> </tr> </table> </itemtemplate> </ASP: repeater>
</Body>
</Html>

 

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

Related Keywords:
wordpress the field use and function first use in function use function in sentence mouse recorder and repeater access use function in query called function and calling function in c

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

What's Trending
Top 10 Tags
datastax versions naming convention zookeeper client class definition md5 microsoft sql server 2005 data structures exception handling error handling
Top 10 Keywords
microsoft download center down wordpress address url site address url wordpress address url windows installer 4 0 download 302 not found web address url definition site address url wordpress db2 integer mac os installation step by step pdf abbreviation for return

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    Open a Ticket

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

    Learn More