Connect to a Database using OleDbConnection - CSharp Database

CSharp examples for Database:Connection

  1. HOME
  2. CSharp
  3. Database
  4. Connection

Description

Connect to a Database using OleDbConnection

Demo Code


using System;//from  ww  w. ja v  a 2 s  .  c om
using System.Data;
using System.Data.SqlClient;
using System.Data.OleDb;

class MainClass
    {
        public static void Main()
        {
            // Create an empty OleDbConnection object.
            using (OleDbConnection con = new OleDbConnection())
            {
                // Configure the OleDbConnection object's connection string.
                con.ConnectionString =
                    "Provider=SQLOLEDB;" +         // OLE DB Provider for SQL Server
                    @"Data Source=.\sqlexpress;" + // local SQL Server instance
                    "Initial Catalog=Northwind;" + // the sample Northwind DB
                    "Integrated Security=SSPI";      // integrated Windows security

                // Open the database connection.
                con.Open();

                // Display information about the connection.
                if (con.State == ConnectionState.Open)
                {
                    Console.WriteLine("OleDbConnection Information:");
                    Console.WriteLine("  Connection State = " + con.State);
                    Console.WriteLine("  Connection String = " +
                        con.ConnectionString);
                    Console.WriteLine("  Database Source = " + con.DataSource);
                    Console.WriteLine("  Database = " + con.Database);
                    Console.WriteLine("  Server Version = " + con.ServerVersion);
                    Console.WriteLine("  Timeout = " + con.ConnectionTimeout);
                }
                else
                {
                    Console.WriteLine("OleDbConnection failed to open.");
                    Console.WriteLine("  Connection State = " + con.State);
                }
                // At the end of the using block Dispose() calls Close().
            }
        }
    }

Result


Related Tutorials