Recordset In Session!

Discussion in 'ASP General' started by Arpan, Sep 28, 2005.

  1. Arpan

    Arpan Guest

    How do I store an entire recordset in one single Session variable?

    Thanks,

    Arpan
     
    Arpan, Sep 28, 2005
    #1
    1. Advertising

  2. Arpan

    Prabhat Guest

    "Arpan" <> wrote in message
    news:...
    > How do I store an entire recordset in one single Session variable?
    >
    > Thanks,
    >
    > Arpan


    I will suggest you to save the recordset into Session Array and use the
    array where ever you want. Go for such big session variable (either
    Recordset or Array) only if you require all the fields / value of that
    recordset.

    Hope this will help you.
    Prabhat
     
    Prabhat, Sep 28, 2005
    #2
    1. Advertising

  3. Arpan

    Arpan Guest

    Thanks, Prabhat, for your suggestion but how do I create such a Session
    array to save the recordset?

    Thanks once again,

    Regards,

    Arpan
     
    Arpan, Sep 29, 2005
    #3
  4. Arpan

    Prabhat Guest

    "Arpan" <> wrote in message
    news:...
    > Thanks, Prabhat, for your suggestion but how do I create such a Session
    > array to save the recordset?
    >
    > Thanks once again,
    >
    > Regards,
    >
    > Arpan


    Hi,

    1st you open the recordset for the SQL what ever you want and then use the
    below statement to save the recordset to session array.

    Session("arrRecords") = rs.GetRows

    Now you can destroy your record set and use the Session("arrRecords") where
    ever you want.

    Hope this will help you.
    Thanks
    Prabhat
     
    Prabhat, Sep 29, 2005
    #4
    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. Jeff Smythe
    Replies:
    3
    Views:
    1,328
    Jeff Smythe
    Jan 2, 2004
  2. =?Utf-8?B?Um9iSEs=?=
    Replies:
    4
    Views:
    5,434
    =?Utf-8?B?Um9iSEs=?=
    Apr 11, 2007
  3. Jazzis
    Replies:
    2
    Views:
    280
    Jazzis
    Sep 23, 2003
  4. Hung Huynh
    Replies:
    8
    Views:
    348
    Bob Barrows
    Sep 24, 2003
  5. Replies:
    1
    Views:
    144
    Bob Barrows [MVP]
    Apr 24, 2007
Loading...

Share This Page