Just gotta say that the SqlCommandBuilder class absolutely rocks! For simple CRUD operations you should do yourself a favour and take a look at this. Usage is as simple as:


    SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Pubs", connectionString);

    SqlCommandBuilder bld = new SqlCommandBuilder(da);

    da.UpdateCommand = bld.GetUpdateCommand();
    da.InsertCommand = bld.GetInsertCommand();
    da.DeleteCommand = bld.GetDeleteCommand();

make your changes to your DataSet and then call the Update method on your DataAdapter to get the changes back to SQL and voila!