Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Connection for OleDb

using System; using System.Data; using System.Data.OleDb;     class ConnectionOleDb     {         static void Main()         {             OleDbConnection conn = new OleDbConnection(@"provider = sqloledb;data source = .\sqlexpress;integrated security = sspi;");             try             {                 conn.Open();                 Console.WriteLine("\tConnection String: {0}",conn.ConnectionString);                 Console.WriteLine("\tDatabase: {0}",conn.Database);                 Console.WriteLine("\tDataSource: {0}",conn.DataSource);                 Console.WriteLine("\tServerVersion: {0}",conn.ServerVersion);                 Console.WriteLine("\tState: {0}",conn.State);             }             catch (OleDbException e)             {                 Console.WriteLine("Error: " + e);             }             finally             {                 conn.Close();                 Console.WriteLine("Connection closed.");             }          }     }