Listing 2: Reading all the data from the table named "BackChat" into a DataSet named "ds."
private System.Data.OleDb.OleDbConnection dbConn; private System.Data.OleDb.OleDbDataAdapter dbAdapter; private System.Data.OleDb.OleDbCommandBuilder custCB; private System.Data.DataSet ds; dbConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + sPath); dbConn.Open(); dbAdapter = new OleDbDataAdapter(); dbAdapter.SelectCommand = new OleDbCommand("SELECT * FROM Backchat", dbConn); ds = new DataSet(); dbAdapter.Fill(ds,"BackChat"); custCB = new OleDbCommandBuilder(dbAdapter); //you'll see how useful this is later