Eric,
If you update your SQL table with a SP, you can have the SP return the identity field for you as an output parameter.
HTH,
~~Bonnie
>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?