OleDbConnection.State : OleDbConnection « System.Data.OleDb « C# / C Sharp by API

1. C# / C Sharp by API
2. System.Data.OleDb
3. OleDbConnection

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

   
    
  

Related examples in the same category