DataReader & Connection

[TookiTooki]

Hi everyone,

 

I'm 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 there's an open datareader attached to a connection?

 

Greetz,

Tooki

[Robby]

you can check the connection...

 

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