Mega Code Archive

 

Categories / C# by API / System Data Oledb

 

OleDbConnection State

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