Output properties for OleDbConnection : OleDbConnection « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. OleDbConnection

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();       
    }
}

Connection String :Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\Northwind.mdb, DataSource :c:\No
rthwind.mdb, Provider :Microsoft.Jet.OLEDB.4.0, Server Version:04.00.0000, Connection Time Out:15