Read a recordset into a variable so I can disconnect from DB and use results?

Discussion in 'ASP General' started by Noozer, Feb 6, 2006.

  1. Noozer

    Noozer Guest

    This seem to be a simple question, but I'm having no luck with Google
    keywords...

    I have an some ASP in which I open a recordset via a connection to a MSSQL
    database. I don't want to keep the database connection open while I'm
    processing the data from the resulting recordset.

    Is there a method that I can use to copy the recordset into an array
    (collection, etc), the close my DB connnection and finally process the data
    I copied from the recordset?
    Noozer, Feb 6, 2006
    #1
    1. Advertising

  2. Noozer

    Mike Guest

    Noozer wrote:
    > This seem to be a simple question, but I'm having no luck with Google
    > keywords...
    >
    > I have an some ASP in which I open a recordset via a connection to a MSSQL
    > database. I don't want to keep the database connection open while I'm
    > processing the data from the resulting recordset.
    >
    > Is there a method that I can use to copy the recordset into an array
    > (collection, etc), the close my DB connnection and finally process the data
    > I copied from the recordset?


    And if you crosspost, make sure the follow-up goes to all the groups
    that you originally posted to. That way, people don't waste time
    responding to something that has already been answered.
    Mike, Feb 6, 2006
    #2
    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. mkhmer
    Replies:
    1
    Views:
    356
    Shawn Wildermuth (C# MVP)
    Jul 17, 2006
  2. Elf M. Sternberg
    Replies:
    1
    Views:
    413
    Andrew Clover
    Jul 5, 2003
  3. Tiwkiz
    Replies:
    0
    Views:
    427
    Tiwkiz
    Jan 30, 2007
  4. Hung Huynh
    Replies:
    8
    Views:
    280
    Bob Barrows
    Sep 24, 2003
  5. Roger

    How to grab results from recordset

    Roger, Jun 18, 2004, in forum: ASP General
    Replies:
    3
    Views:
    114
    Bob Barrows [MVP]
    Jun 18, 2004
Loading...

Share This Page