DataSetCommand
// Create a DataSetCommand
ADODataSetCommand dataSetCommand = new ADODataSetCommand(
"Select * from authors", cnn);
dataSetCommand.FillDataSet(pubs, "Authors");
// make some changes to the author data in the dataset
pubs.Tables[0].Rows[0]["state"]="WA";
// submit changes back to datasource
dataSetCommand.Update(pubs, "Authors");