Really nice way to handle Paging, Filtering and Sorting from SQL itself.
In day to day work we often need data to displayed in Grid that needs sorting, paging and filtering on User Interface whether web or windows. I often struggle to find a unified solution. I found that best way is to have fetch data in required format from stored procedure and just have presentation logic on UI rather than mixing a lot of logic for Sorting, Paging and Filtering. Here I am presenting a simple approach to have data from Stored procedure in required format based on given parameters.
View original post 1,468 more words