Hello, 

I use the SQLCommandBuilder to automatically generate the Transact-SQL
statements required to reconcile changes made to my DataSet. This works
fine for the dataset I use since it contains only one table. 
The primary key of my table is a numeric type with Identity Seed
(Increament Seed:1). When I add a new row to my dataset I leave the ID
empty(dbNull) because it will be generated by SQL on updating the
records in my table. 

And now the question :-) 

Is there a way to return that new ID in my dataset after the update ? 

thx in advance,

christophe