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

Discussion in 'ASP .Net Datagrid Control' started by Joel Thornton, Feb 17, 2005.

  1. 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
     
    Joel Thornton, Feb 17, 2005
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Mo
    Replies:
    1
    Views:
    4,416
    FFlannery
    Jan 30, 2004
  2. Max
    Replies:
    2
    Views:
    635
    Craig Deelsnyder
    Jan 13, 2004
  3. ck388
    Replies:
    1
    Views:
    11,050
    Brock Allen
    Jun 6, 2005
  4. Christian Hofmann

    GridView sorting/ paging without Javascript?

    Christian Hofmann, Oct 20, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    1,123
    Christian Hofmann
    Oct 20, 2005
  5. sck10
    Replies:
    0
    Views:
    700
    sck10
    Jun 21, 2007
  6. Roberto Kohler

    Gridview - how to use stored procedures to update

    Roberto Kohler, Dec 12, 2005, in forum: ASP .Net Datagrid Control
    Replies:
    6
    Views:
    1,041
    pavan kumar
    Dec 7, 2006
  7. mc
    Replies:
    0
    Views:
    862
  8. Joel  Thornton

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

    Joel Thornton, Feb 17, 2005, in forum: ASP .Net Web Controls
    Replies:
    0
    Views:
    516
    Joel Thornton
    Feb 17, 2005
Loading...