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






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








32.6.OleDbConnection
32.6.1.Output properties for OleDbConnection
32.6.2.OleDbConnection connection state
32.6.3.Connection Pooling Sample
32.6.4.Connecting to an OLE DB Data Source
32.6.5.Connection for OleDb
32.6.6.Retrieving Data from a Text File
32.6.7.Connect to SqlServer using OleDbConnection
32.6.8.Retrieves a list of tables in a database
32.6.9.Reading Access Data with OleDbConnection