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