private static void OpenConnection(string connectionString)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
Console.WriteLine("ServerVersion: {0}", connection.ServerVersion);
Console.WriteLine("State: {0}", connection.State);
}
}
if you want to check by condition then...:)
String strConn = System.Configuration.ConfigurationManager.ConnectionStrings["conStr"].ToString();
OracleConnection con = new OracleConnection(strConn);
if(if(con.State == ConnectionState.Open)
{
lable1.text= "Connection is Open";
}
else
{
lable1.text= "Connection is close";
}