using System;
 
using System.Collections.Generic;
 
using System.Linq;
 
using System.Text;
 
using System.IO;
 
//
 
//  namespaces needed fo data access
 
//
 
using System.Data;
 
using System.Data.OleDb;
 
 
 
namespace msaccess
 
{
 
    class Program
 
    {
 
        static void Main(string[] args)
 
        {
 
            //
 
            //  Initialization
 
            //
 
 
 
            string ic_number = "648937693";
 
 
 
            string path = Directory.GetCurrentDirectory();
 
            path += "\\Folder\\MyDatabase.mdb";
 
 
 
            // Connection object
 
            var cn = new OleDbConnection(
 
                "Provider=Microsoft.Jet.OLEDB.4.0;" +
 
                "Data Source=" + path);
 
 
 
            // sql command object, that will select your data
 
            var cmd = new OleDbCommand(
 
                "select MyField1, MyField2 from MyTable where ICNumber = @icnumber", cn);
 
 
 
            // this will insert "648937693" in @icnumber in SQL select statement
 
            cmd.Parameters.AddWithValue("@icnumber", ic_number);
 
 
 
            // table adapter
 
            // it can execute sql commands 
            // and fill table objects with data from database
 
            var adapter = new OleDbDataAdapter(cmd);
 
 
 
            var table = new DataTable();
 
 
 
            // here adapter opens connection
 
            // retrieves data with select command
 
            // and stores it in table object
 
            adapter.Fill(table);
 
 
 
            // iterate through rows of data
 
            foreach (DataRow row in table.Rows)
 
            {
 
                // do your stuff
 
                string s = string.Format(
                              "MyField1: {0} MyField2: {1}", 
                              row["MyField1"], row["MyField2"]);
 
                Console.WriteLine(s);
 
            }
 
 
 
            // wait
 
            Console.ReadLine();
 
        }
 
    }
 
}