Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Output properties for 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