I have a small table in SQL Server which has an Identity field.

I retreive this table into a data adapter and fill a dataset from it. This data set is then bound to a data grid. Up to this point, everything is OK.

I have then added a Save button in which I update the data adapter (dataadapter.update(dataset, ...)).

My question is the following:
If I add new rows to my datagrid, what is the best method to update the grid to have it show the value of the identity field after I have clicked the save button?