Maybe I'm missing something, but I'm not sure how to get a DataAdapter to give me back the identity value of inserted rows, short of completely refreshing the DataSet?
Basically I've got a DataSet in memory and am .Add()ing rows to one of the DataTables. Later I call SqlDataAdapter.Update passing in my DataSet, and the columns that are set up as Identity columns remain null. Is there any way short of refilling the DataSet to get the identity values to update? TIA Adam.. You can read messages from the Advanced DOTNET archive, unsubscribe from Advanced DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.