How to check whether Connection is Open or not?

Answer:

With the help of State property of SqlConnection object,we can check whether Connection is Open or Close.
It has ConnectionState as Enum which has Open value.

For Example:-

if (con.State == ConnectionState.Open)

    con.Close();

Here con is our SqlConnection object.