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

Question

I have a console application in Visual Studio 2008 and i want to connect it to a database in Microsoft Access 2007, i want to connect the database to the application so that a user can fill in information to the database from the application...

Pls how do i do that???

Sandeep Singh Shekhawat · Answer

// 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. 
{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.
{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]); } } }