Eric,

Someone else may have to chime in here and help. We haven't been using the DataAdapter.Update() methods. We do all our data access through SPs so we have to do things a little differently. Working through SPs is easy enough, but from what I understand of the DataAdapter.Update(), it does a lot of things for you automatically (like determining which rows have changes) which we have to do manually in order to use a SP. So, in your case, maybe that's not the way to go. Unfortunately, I can't think of an easier way to get your identity column back after you update your row, so unless anyone else has any other suggestions, maybe you'll have to think about doing it my way.

Lemme know if you need more help on using the SPs, if you decide to go that route.

~~Bonnie


>The data adapter update is a kind of batch update. I could give a stored proc to my UpdateCommand but will it update the dataset and refresh the grid?
>
>
>>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?