This step of the VIDEO TUTORIAL will demonstrate how to implement custom paging process for GridView data web control for displaying records at run time. In this step, how custom paging process depends on three primary attributes that include StartRowIndex, Maximum Rows and Total Record Count is explained in detail. For detailed information and source code for this step, please refer to the original article.

This step of the VIDEO TUTORIAL will emphasize on how to add an additional method to the Northwind.xsd typed dataset’s Products table adapter. This new method ‘TotalNumberOfProducts’ is added to the Products table adapter using Table Adapter Query Configuration wizard. This method returns the total number of records that have to be paged through the GridView control’s display interface at run time. Following which, we have to create a wrap around in the business logic layer (in ProductsBLL.cs file) for this newly created data access layer method. For detailed information and source code for this step, please refer to the original article.

This step of the VIDEO TUTORIAL will demonstrate in adding GetProductsPaged( ) method (to the DAL) that accepts ‘startIndex’ and ‘maximumRows’ as parameters for returning a subset of the Total Number of Records for custom paging purposes. In order to accomplish this, a new ranking function ROW_NUMBER is utilized. Finally, a wrap around method for this newly created data access layer method is created in the ProductsBLL business logic layer. For detailed information and source code for this step, please refer to the original article.