This step of the VIDEO TUTORIAL will elaborate on how to support sorting of data in addition to custom paging that we have implemented in the previous tutorial. In order to accomplish that we need to supply ‘sortExpression’ as one of the parameters to the custom stored procedure ‘GetProductsPaged’ and rename it as ‘GetProductsPagedAndSorted’. This tutorial will explain the creation of the new stored procedure that accepts the ‘sortExpression’ as one of the parameters to support sorting during custom paging process. For detailed information and source code for this step, please refer to the original article.

This step of the VIDEO TUTORIAL will display on how to create a new data access layer method by augmenting the Northwind.xsd typed dataset to make use of newly created ‘GetProductsPagedAndSorted’ stored procedure. This is accomplished by adding a new method to the Products table adapter by launching table adapter query configuration wizard. Once the ‘GetProductsPagedAndSorted’ method is added to the products table adapter and wrap around is also added to ProducstBLL business logic layer to invoke this method from DAL. For detailed information and source code for this step, please refer to the original article.

This step of the VIDEO TUTORIAL will familiarize the user on how to bind the GridView data web control to make use of the newly created ‘GetProductsPagedAndSorted’ method from the ProductsBLL business logic layer. In order to accomplish this, we have moved the declarative mark up from the SimplePagingAndSorting.aspx page from the previous tutorial to SortParameter.aspx page. In addition, we also need to rebind the ObjectDataSource control to use the ‘GetProductsPagedAndSorted’ for the SELECT tab of the Object Data Source configuration wizard. Finally, the SortParameter.aspx web page is examined at run time to demonstrate its functionality of custom paging and sorting.For detailed information and source code for this step, please refer to the original article.