Posted by Dan Guzman on 04/15/07 12:28

> or is there a more approiate way

How about:

if (oconn.State == ConnectionState.Closed)




--
Hope this helps.

Dan Guzman
SQL Server MVP

"Mike J" <vettes_n_jets@sbcglobal.net> wrote in message
news:GRSTh.5253$5e2.1513@newssvr11.news.prodigy.net...
> how to check the connection state sql
>
> if (oconn.State.tostring()="Closed")
>
> or is there a more approiate way
> thanks
> MJ
>
>

[Back to original message]