DataReader & Connection

[TookiTooki]

Hi everyone,

Im writing a web application that makes a connection to a sql server.
Only one datareader can be associated with a connection... how can one quickly see if theres an open datareader attached to a connection?

Greetz,
Tooki

 

[Robby]

you can check the connection...

If mySqlConn.State = ConnectionState.Closed Then
      mySqlConn.Open()
endif