Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Datagrid Control > GridView paging/sorting - will it work with stored procedures?

Thread Tools

GridView paging/sorting - will it work with stored procedures?

Joel Thornton
Posts: n/a
Can anyone tell me whether the new ASP.NET 2.0 GridView control
supports sorting and paging when the data source is a SQL stored
procedure, e.g. 'GetEmployee'?

If so, does that mean that the control actually retrieves the entire
dataset from the stored procedure, caches it locally and then
pages/sorts from that? Or is there some other clever technique used by
Yukon to handle this?

Also in the case of plain old SELECT statements, is the whole dataset
cached locally, or does ASP.NET actually just get the data it needs
from the database by making new SELECT queries against the database
(dynamically modifying ORDER BY, TOP, etc. clauses)?

Thanks for any info you can provide. GridView's native sorting/paging
sounds nice but I want to make sure I don't run into some performance
nightmares when I try to use its paging/sorting on a million-record
rowset retrieved from a stored procedure.

Joel Thornton

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
GridView doesn't refresh schema after changes were made in bounded stored procedure Orit ASP .Net 1 06-26-2007 05:35 PM
GridView Paging: Binding to Oracle Stored Procedure sck10 ASP .Net 0 06-21-2007 09:43 PM
GridView Hierarchical View - Gridview in Gridview =?Utf-8?B?bWdvbnphbGVzMw==?= ASP .Net 1 05-09-2006 06:48 PM
Gridview sorting - with template columns and stored procedure =?Utf-8?B?RG9ydGU=?= ASP .Net 0 12-14-2005 06:58 AM
GridView paging/sorting - will it work with stored procedures? Joel Thornton ASP .Net Web Controls 0 02-17-2005 09:41 PM