Connection? I didn't work  by connection directly. I only define a connection for OleDbDataAdapter.SelectCommand.Connection .
Then (1)I've used OleDbDataAdapter to fill some DataTables of a DataSet. (2) I've used DataSet.Select(...) method to retrive data. (3) I've called OleDbDataAdapter.Update(...) to match DataTable changes and my database.