sqlConnection.State.ToString().Equals( "Open" )

[dky1e]

sqlConnection.State.ToString().Equals( "Open" )

There has to be a cleaner way to check the state of SqlConnection (???)

[V. Lorenzo]

Hi:

Yes!! Of course. Try this:

if (m_Connection.State == ConnectionState.Open)
...do what ever needs to be done if the collection is open...

m_Connection is the instance of the connection class.

VictorL

[dky1e]

Nice...
I knew threre was a better way :)!