How to connect an Access Database to a C# Console Applicatio

// OleDbSample.cs

using System;

using System.Data;

using System.Data.OleDb;

using System.Xml.Serialization;

public class MainClass

{

    public static void Main()

    {

        // Set Access connection and select strings.

        // The path to BugTypes.MDB must be changed if you build

        // the sample from the command line:

#if USINGPROJECTSYSTEM

            string strAccessConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\\..\\BugTypes.MDB";

#else

        //string strAccessConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=BugTypes.MDB";

        string strAccessConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;

                                Persist Security Info=False";

#endif

        string strAccessSelect = "SELECT * FROM Categories";

        // Create the dataset and add the Categories table to it:

        DataSet myDataSet = new DataSet();

        OleDbConnection myAccessConn = null;

        try

        {

            myAccessConn = new OleDbConnection(strAccessConn);

        }

        catch (Exception ex)

        {

            Console.WriteLine("Error: Failed to create a database connection. \n{0}", ex.Message);

            return;

        }

        try

        {

            OleDbCommand myAccessCommand = new OleDbCommand(strAccessSelect, myAccessConn);

            OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(myAccessCommand);

            myAccessConn.Open();

            myDataAdapter.Fill(myDataSet, "Categories");

        }

        catch (Exception ex)

        {

            Console.WriteLine("Error: Failed to retrieve the required data from the DataBase.\n{0}", ex.Message);

            return;

        }

        finally

        {

            myAccessConn.Close();

        }

        // A dataset can contain multiple tables, so let's get them

        // all into an array:

        DataTableCollection dta = myDataSet.Tables;

        foreach (DataTable dt in dta)

        {

            Console.WriteLine("Found data table {0}", dt.TableName);

        }

        // The next two lines show two different ways you can get the

        // count of tables in a dataset:

        Console.WriteLine("{0} tables in data set", myDataSet.Tables.Count);

        Console.WriteLine("{0} tables in data set", dta.Count);

        // The next several lines show how to get information on

        // a specific table by name from the dataset:

        Console.WriteLine("{0} rows in Categories table", myDataSet.Tables["Categories"].Rows.Count);

        // The column info is automatically fetched from the database,

        // so we can read it here:

        Console.WriteLine("{0} columns in Categories table", myDataSet.Tables["Categories"].Columns.Count);

        DataColumnCollection drc = myDataSet.Tables["Categories"].Columns;

        int i = 0;

        foreach (DataColumn dc in drc)

        {

            // Print the column subscript, then the column's name

            // and its data type:

            Console.WriteLine("Column name[{0}] is {1}, of type {2}", i++, dc.ColumnName, dc.DataType);

        }

        DataRowCollection dra = myDataSet.Tables["Categories"].Rows;

        foreach (DataRow dr in dra)

        {

            // Print the CategoryID as a subscript, then the CategoryName:

            Console.WriteLine("CategoryName[{0}] is {1}", dr[0], dr[1]);

        }

    }

}