 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / General / March 2008GridView sorting paging : perform in db ?
In regard to a GridView that must support searching, filtering, sorting, and paging ... There is a tradeoff in performing the sorting and paging in the database versus to creating a CLR sort expression and allowing the GridView to perform the sorting and paging. How do people feel about each option for (1) simple sorts (alphabetical, compound alphabetical) (2) complex sorts (derived attributes, date-time manipulations, etc.) It really depends on how many rows you have in the resultset that will be paged. If it is a manageable number. you can cache the results and simply rebind the datasource based on the current page of results. If it is a very large number of rows, this becomes inefficient because of the large number of results and you'll be better off using custom paging via SQL RowNumber or similar techniques. A simple google search on "Gridview Custom Paging" will provide some good samples to study. -- Peter Site: http://www.eggheadcafe.com UnBlog: http://petesbloggerama.blogspot.com Short Urls & more: http://ittyurl.net > In regard to a GridView that must support searching, filtering, sorting, and > paging ... [quoted text clipped - 8 lines] > > (2) complex sorts (derived attributes, date-time manipulations, etc.)
Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.