Stored ProcedureSuppose we have 2000 records in a table and we want to display only 10 records in a page; then why fetch 2000-10 = 1990 extra records. These extra records take too much bandwidth and reduce performance. So here is how to solve the problem step-by-step Step 1: Create a Stored Procedure for paging, as in:In the above Stored Procedure we are passing three parameters, two input parameters and one output parameter. The input parameters @PageIndex and @PageSize are to fetch records. These parameters represent the page number and how may records to display on that page. The output parameter @TotalRow is to display how many total records are in the table.Step 2: Use a GridView Now I use a grid view that shows employee data.Step 3: Use a RepeaterA Repeater Control is used as a pager (to change pages). It uses a linkbutton that shows the page number in the bottom of the grid view.Step 4: Fill Employee Data in GridView I create a method that gets all employee specific page data and the total number of records in the table. Here I define the pagesize as 5, in other words each page will display only 5 records. TotalRow is used to determine how many rows there are in the table so we can create paging according.Step 5: Create pager Here I create the page number depending on the total number of records in the table. Here we are also adding two extra link buttons; these are "First" and "Next". These page numbers are bound with the repeater control.Step 6: Change Page IndexWhen the page index changes then again new data is obtained depending on the new page and page size.Step 7: First time load data We fill the grid view when the page loads the first time.Step 8: Output
Sandeep Singh Shekhawat is a Software Developer. He is
awarded for C# Corner MVP(2013,2014, 2015 and 2016) and CodeProject MVP (2015). His
three articles at CodeProject are prize wining in article competition. His more
t... Read more
C# Corner. All contents are copyright of their authors.