ADODB connection

            string SqlStr;
            ADODB.Connection Conn1;
            ADODB.Recordset Rs1;
            Conn1 = new ADODB.Connection();
            Rs1 = new ADODB.Recordset();
            Conn1.Open("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Leo\\Documents\\Visual Studio 2008\\Projects\\CodeDatabase\\CodeDatabase\\CodeDatabase.mdb;Persist Security Info=False;", "", "", 0 );
            SqlStr = "SELECT * FROM Codes";

            // Open Recordset
            Rs1.Open (SqlStr, Conn1, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockReadOnly, 0);
            // Check if anything in the table
            if (Rs1.EOF == false)

            // If so, loop and get all the information to fill the list
            do
            {
                lstSubjects.Items.Add(Rs1.Fields["ID"].Value + "~" + Rs1.Fields["_Subject"].Value);
                Rs1.MoveNext();
            }
            while (Rs1.EOF == false);


            // Call CloseDatabase
             Conn1.Close();
             Conn1 = null;
        }