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?
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com