connection state

[Dino L.]

I wanna open connection, just if connection is closed

if(Konekcija.State != ConnectionState.Open)
Konekcija.Open();

But this code always wants to open new connection? What is wrong with
this IF statment?

 

[Joey Callisay]

how about
if(Konekcija.State == ConnectionState.Closed) Konekcija.Open();

 

[Nicholas Paldino [.NET/C# MVP]]

Dino,

I would check against it being closed, instead of it being not open.
There are a number of other states (broken, connecting, etc, etc) which will
trigger this condition to fail. I would do:

// Check to see if the state is closed.
if (Konekcija.State == ConnectionState.Closed)
{
// Open the connection.
Konekcija.Open();
}

Hope this helps.