Output properties for OleDbConnection : OleDbConnection : 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()  {
              string  ConnectionString  =  @"Provider=Microsoft.Jet.OLEDB.4.0;  Data  Source=c:\Northwind.mdb";
              OleDbConnection  conn  =  new  OleDbConnection(ConnectionString);

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

              //  Show  the  connection  properties
              Console.WriteLine(  "Connection  String  :"+conn.ConnectionString  
                      +",  DataSource  :"+  conn.DataSource.ToString()
                      +",  Provider  :"+  conn.Provider.ToString()  
                      +",  Server  Version:"+  conn.ServerVersion.ToString()
                      +",  Connection  Time  Out:"+  conn.ConnectionTimeout.ToString()  );

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