I have a dataadapter feeding into a dataset that is bound to a datagrid. When the user adds a record I call the update method of the dataadapter which writes back to the database.

Now here is the problem even though I call the datagrid.refresh method, the id field in the datagrid is not being populated So it looks like the database is being written to, but the dataset doesn't get the ids of the new records back. Is there anyway to force the return of the id fields into the dataset that is better than recreating the dataset from scratch again?