Hi all, I recently made a test program to access a DB2 database and all I had to do was use an OleDbConnection, OleDbDataAdapter, and a DataSet:

Code:
       public System.Data.DataSet ReadMyData(string myConnString) 
        {
            string mySelectQuery = "SELECT field1, field2,field3 FROM table1 ";
            mySelectQuery += "WHERE field1=1234";
            OleDbConnection myConnection = new OleDbConnection(myConnString);
            myConnection.Open();
            OleDbDataAdapter dataAdapter = new OleDbDataAdapter(mySelectQuery, myConnection);
            System.Data.DataSet DataSet1 = new System.Data.DataSet();
            dataAdapter.Fill(DataSet1);
            return DataSet1;
        }
Which data structures would I use to access an Access database?


Thanks!

Jim