This post explains and demonstrates how to implement following things Custom Paging: Returning a set of records for the given page number and page size Dynamic query: Querying based on the where string passed thru parameter Dynamic sorting: Sorting based on the sort expression passed thru parameter SPExecuteSql: Executing sql statements included within parameters Common Table Expression: Similar to table variablefunction rownumber(): returns the current row number in a result setThe following code...
|
2
Shouts |
|
|||
No comments yet, be the first one to post comment.