Results 1 to 2 of 2

Thread: Check if connection is open?

  1. #1

    Thread Starter
    Fanatic Member Kings's Avatar
    Join Date
    Aug 2001
    Posts
    673

    Check if connection is open?

    How can I check if I have a connection open (to my DB)?

    In classic ASP, I used this
    Code:
    If objRS.State <> "0" Then objRS.Close
    What can I use in ASP.NET?
    This doesn't work;
    VB Code:
    1. Dim objDataReader as OleDbDataReader
    2.  
    3. 'now this doesn;t work
    4. If objDataReader.State <> "0" Then objDataReader.Close()

    Anyone has an idea?

    Thanks
    K i n g s

  2. #2

    Thread Starter
    Fanatic Member Kings's Avatar
    Join Date
    Aug 2001
    Posts
    673
    nevermind, someone else already answered this.
    K i n g s

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width