Connect to Access database : SqlConnection « Database ADO.net « C# / C Sharp






Connect to Access database



// connect to Access database

/*
 * C# Programmers Pocket Consultant
 * Author: Gregory S. MacBeth
 * Email: gmacbeth@comporium.net
 * Create Date: June 27, 2003
 * Last Modified Date:
 * Version: 1
 */
using System;
using System.Data.OleDb;

namespace Client.Chapter_13___ADO.NET
{
    public class ConnectingToAccess
    {
        static void Main(string[] args)
        {
            OleDbConnection MyConnection = new OleDbConnection (
            @"Provider=Microsft.Jet.OLEDB.4.0; Data Source = c:\MyAccessDB.mdb");
            MyConnection.Open();            
        }
    }
}


           
       








Related examples in the same category

1.SqlConnection propertiesSqlConnection properties
2.WorkstationId
3.ConnectionTimeout
4.PacketSize
5.Connection String
6.DataSource
7.SqlConnection state change event
8.SqlConnection: info message event handler
9.Creating SQL Connections
10.Create SqlCommand object