Fetching connexion

[Shurikn]

I have this error coming up and I dont know what it means or what to do with it:

An unhandled exception of type System.InvalidOperationException occurred in system.data.dll

Additional information: ExecuteReader requires an open and available Connection. The connections current state is Open, Fetching.

Why would the conection state change to Fetching? and how can I turn it back to normal?

 

[Machaira]

Sounds like you have another query thats running when youre calling ExecuteReader.

 

[bri189a]

Or you never close the connection from your last call. Make sure you are calling dispose also!

 

[michael_hk]

Or you never close the connection from your last call. Make sure you are calling dispose also!

As far as I know, calling .Dispose() will destroy the connection and the connection will not return to the pool. So make sure you know the effect of calling it.