SqlConnection connection state : SqlConnection : ADO.Net C# Examples

    
using  System;
using  System.Data;
using  System.Data.SqlClient;
using  System.Data.OleDb;

class  MainClass
{
        public  static  void  Main()
        {
                using  (SqlConnection  con  =  new  SqlConnection())
                {
                        con.ConnectionString  ="server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated  Security=SSPI;";        

                        con.Open();

                        if  (con.State  ==  ConnectionState.Open)
                        {
                                Console.WriteLine("SqlConnection  Information:");
                                Console.WriteLine("    Connection  State  =  "  +  con.State);
                                Console.WriteLine("    Connection  String  =  "  +  con.ConnectionString);
                                Console.WriteLine("    Database  Source  =  "  +  con.DataSource);
                                Console.WriteLine("    Database  =  "  +  con.Database);
                                Console.WriteLine("    Server  Version  =  "  +  con.ServerVersion);
                                Console.WriteLine("    Workstation  Id  =  "  +  con.WorkstationId);
                                Console.WriteLine("    Timeout  =  "  +  con.ConnectionTimeout);
                                Console.WriteLine("    Packet  Size  =  "  +  con.PacketSize);
                        }
                        else
                        {
                                Console.WriteLine("SqlConnection  failed  to  open.");
                                Console.WriteLine("    Connection  State  =  "  +  con.State);
                        }
                }

        }
}