Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Get connection state and server version

using System; using System.Data.OracleClient;   class Class1   {     static void Main(string[] args)       {             String connString = "User Id=oranetuser;Password=demo";             OracleConnection oraConn = new OracleConnection(connString);             try             {                 oraConn.Open();                 Console.WriteLine(oraConn.ConnectionString.ToString() + "\n");                 Console.WriteLine(oraConn.State.ToString() + "\n");                 Console.WriteLine(oraConn.ServerVersion.ToString());             }             catch (Exception ex)             {                 Console.WriteLine("Error occured: " + ex.Message);             }             finally             {                 if (oraConn.State == System.Data.ConnectionState.Open)                 {                     oraConn.Close();                 }             }     }   }