Show the connection properties for SqlConnection : SqlConnection : ADO.Net C# Examples

    
using  System;
using  System.Drawing;
using  System.Collections;
using  System.ComponentModel;
using  System.Windows.Forms;
using  System.Data;
using  System.Data.OleDb;
using  System.Data.SqlClient;


public  class  MainClass{
        static  void  Main()  {
              //  Create  a  Connection  Object
              string  ConnectionString  ="server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated  Security=SSPI;";
              SqlConnection  conn  =  new  SqlConnection(ConnectionString);

              //  Open  the  connection
              if(  conn.State  !=  ConnectionState.Open)
                      conn.Open();


              //  
              Console.WriteLine(  "Connection  String  :"+conn.ConnectionString  
                      +  ",  Workstation  Id:"+  conn.WorkstationId.ToString()
                      +",  Packet  Size  :"+  conn.PacketSize.ToString()
                      +",  Server  Version  "+  conn.ServerVersion.ToString()
                      +",  DataSource  :"+  conn.DataSource.ToString()
                      +",  Server  Version:"+  conn.ServerVersion.ToString()
                      +",  Connection  Time  Out:"+  conn.ConnectionTimeout.ToString()  );

              //  Close  the  connection
              if(  conn.State  ==  ConnectionState.Open)
                      conn.Close();              
        }
}