I have a DataSet with 2 related tables. When I save a new record to Table1 using DataAdapter.Update(Table1), I have my stored procedure return back to the DataSet a select of the row added. This does not update the values in the DataTable until I call AcceptChanges on the DataTable. (I need these values updated so that the correct Identity values are set for Table2 before I try to insert the records.) Since this whole process is in the middle of a transaction, I do not want to call AcceptChanges at this time as the transaction might get rolled back.

I must be missing something here. Can someone shed some light on this process for me?

Thanks!!