2
Shouts

Implementing Custom Paging, Sorting and Dynamic query in sql

posted by kcherupakcherupa 890 days, 17 hours, 31 minutes ago
Tuesday, December 15, 2009 5:41:44 AM GMT

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...

category: SQL | clicked: 5 | | source: cherupally.blogspot.com | show counter code
tags: Custom Paging, SORTING, Dynamic Querying

No comments yet, be the first one to post comment.

To post your comment please login or signup