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

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,195
    FFlannery
    Jan 30, 2004
  2. Max
    Replies:
    2
    Views:
    545
    Craig Deelsnyder
    Jan 13, 2004
  3. Roberto Kohler

    Gridview - how to use stored procedures to update

    Roberto Kohler, Dec 12, 2005, in forum: ASP .Net Datagrid Control
    Replies:
    6
    Views:
    712
    pavan kumar
    Dec 7, 2006
  4. mc
    Replies:
    0
    Views:
    736
  5. 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:
    369
    Joel Thornton
    Feb 17, 2005
Loading...

Share This Page