|
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
>
>
Navigation:
[Reply to this message]
|