Code for testing if an OleDbConnection is open or closed 1

[RiverGuy]

I tried the following:

if(con1.State == Closed)
{
con1.Open();
}

That does not work at all. Anyone know the correct syntax?

Thanks.

 

[wushutwist]

It should be:

if (con1.State == ConnectionState.Closed)
{
  con1.Open();
}

Personally I think better design is called for here. You should know at any point in your code whether a connection is open. The problem is that you are proably passing around the same connection to various methods and at some point you can't be sure what state it is in, right? Streamline you code so that the state is obvious, this will help with maintainablility and flexibility down the road.