paging a recordset with many records


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: paging a recordset with many records

  1. #1
    Join Date
    Mar 2004
    Posts
    102

    paging a recordset with many records

    Hi there....

    If I use ADO recordset object properites like pagesize and pagecount in order to use for paging the result set --when I am developing a report (for example)
    in a web-based appl. , then when a user fetches my report for the first time,
    is it true that web server returns all result records to the client and by clicking at "next" link, it shows proper records?

    OR

    the server returns records as many as i have set it by paging properties even for the first time and when the user clicks on "next" link, then again the web server returns another set of result data?

    Whicj one is correct?

    Thank you ver much

    Sonia
    Sonia

  2. #2
    Join Date
    Dec 2003
    Posts
    2,750
    The PageSize and PageCount properties do not limit the number of rows returned from the database. All rows are returned as specified by the SQL statement (or SP) and the web server determines which rows to make available based upon these property settings.
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  3. #3
    Join Date
    Mar 2004
    Posts
    102

    paging a recordset with large amount of result set

    Paul,
    I know that paging a recordset does not limit the number of records return from DB.

    but what about web server?is it true that all te result set will not return from
    server to client for the first time (by executing the query) and by clicking at "next" link, the web server again returns the proper set of result set to the client.?
    Sonia

  4. #4
    Join Date
    Dec 2003
    Posts
    2,750
    Whatever you see in the page is what is being returned to the client. There is no hidden data returned. Only the rows for the logical page are returned to the client browser.

    When the user clicks on the next page (or previous page) link, the request is posted to the server and the PageSize and PageCount properties are used to fetch the next set of data to return to the client.
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  5. #5
    Join Date
    Mar 2004
    Posts
    102
    Paul,

    Thanks alot.
    Sonia

Similar Threads

  1. Replies: 4
    Last Post: 02-10-2002, 02:53 PM
  2. Paging a recordset
    By maya in forum VB Classic
    Replies: 1
    Last Post: 12-19-2001, 08:13 AM
  3. Requerying a reshaped recordset
    By Jonathan Gibbs in forum VB Classic
    Replies: 0
    Last Post: 08-09-2001, 03:34 PM
  4. Open a Recordset object containing no records
    By Sergey in forum VB Classic
    Replies: 2
    Last Post: 03-20-2001, 02:28 PM
  5. Paging through records...
    By Robert Gelb in forum VB Classic
    Replies: 0
    Last Post: 05-09-2000, 03:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center