ASP.NET GridView Tutorial

asp.net gridview paging using a dropdownlist – Part 56

The HTML and the code used in the demo, can be found at the link below.
http://csharp-video-tutorials.blogspot.com/2013/04/aspnet-gridview-paging-using.html

Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists

In this video we will discuss about implementing paging in gridview and controlling the page size and page numbers using a dropdownlist.

We will be modifying the example that we discussed in Part 55. Please watch Part 55, before proceeding with this video.

Step 1: Create a table with 2 rows. The first row should contain 4 TD’s, and the second row should contain 1 TD. The first row should contain the following.
1. Text – Page Size
2. DropDownList – with paze sizes(5, 10, 15, 20)
3. Text – Page Number
4. DropDownList – to list the pages. The number of pages available will be computed dynamically

Since the second row contains, only one TD, set colspan=4 for this TD, so that the width of this one TD spans across 4 columns. Since, we are now going to

use a dropdownlist to display the pages for navigation, we can get rid of the repeater control. Also, set the page size of gridview control to 5.

Step 2: Changes to WebForm1.aspx.cs
1. DatabindRepeater() method name is changed to Databind_DDLPageNumbers(). The page numbers are added to the dropdownlist(ddlPageNumbers)

instead of repeater control.
2. In the Page_Load() event, we are invoking Databind_DDLPageNumbers() method and passing, ZERO as the page index and 5 as the page size.
3. Event handler method linkButton_Click() is deleted as we no longer need it.
4. In GridView1_Sorting(), notice that page size and page index is retrieved from ddlPageSize and ddlPageNumbers dropdownlist respectively.
5. Finally notice the implemenatations of ddlPageSize_SelectedIndexChanged() and ddlPageNumbers_SelectedIndexChanged().

EmployeeDataAccessLayer and the stored procedure used will not change in any way.