Copy codeThe Code is as follows:SET QUOTED_IDENTIFIER ONGOSET ANSI_NULLS ONGOAlter procedure usp_PagingLarge@ TableNames VARCHAR (200), -- table name, which can be multiple tables but cannot be aliases@ PrimaryKey VARCHAR (100), -- primary key,
Public
Actionresult index (
String
Count,
String
Current,
String
CSS){Viewdata [
"
Message
"
]
=
"
Welcome to ASP. net mvc!
"
; Int Allcount = Int . Parse (count ); // Total number of entries Int
This control can be used on gridview,repeater,datagrid,datalist ... Almost all. NET data-bound controls are paged, none refreshed, and the data-bound section can use stored procedures or use SQL statements directly, without any interference with the
In the previous article, we implemented how to enable the datapager control in silverlight4 to implement server-side paging instead of client paging, in the server-side WCF Ria service, we implement a function to retrieve the total number of pages
Drag a DataGrid Control and a datapager control,CodeAs follows:
Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->
Grid
X: Name
= "Layoutroot"
Background
= "White"
>
SDK:
In Asp.net, it is relatively simple to dynamically load controls. Here I am talking about the loading of user controls. A typical example is that the loaded user control contains a send-back event, new data must be retained when it is
Previously, we used the pagination function provided by the GridView. The speed is really slow. We decided that the custom paging Oracle database had more than pieces of data.
AspnetPager is doing well. Use it.
Oracle paging stored procedure:
Create
Download: http://files.cnblogs.com/shengshuai/pager.rar
Source File: http://files.cnblogs.com/shengshuai/FSS_Pager.rar
Add a new control on the toolbar of vs2005. Only one step is required for paging:
Drag pager to the page and set its
First download version 4.3, then install
Problem:
1. In vs. net2005, the control cannot be automatically added to the tool panel. You must manually add an item and select aspnetpager. dll.
2. In the CS file of codebehind, you need using Wuqi.
It is not well written and is for reference only.
Gridpager. ascx:
1
//////////////////////////////////////// //////////////////////////////////////// ///////
Gridpager. ascx. CS:
Using system;
Using system. Data;
Using
: Http://www.webdiyer.com/Products/AspNetPager/Downloads
Aspnetpager paging example: http://www.webdiyer.com/AspNetPagerDemo/ApplyStyles/default.aspx
After the download, you can pull the control into vs. Note that vs2003 cannot be used! The
Ascx control:
Home prev Next End page: 1/0 page Total 0 record to page --%>
jquery Plug-ins:
JQuery.fn.pager = function (RecordCount, opts) {opts = Jquery.extend ({pagesize:10, num_display_entr Ies:10, Current_page:1,
I've been working on a project lately, there are a lot of basic information tables. But all this information is only a few additions and deletions to the relevant operations, most of the tables do not have business flow related operations. If each
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.