Hi, Here's a tricky one. I have a DataSet with two tables, with a parent-child relationship defined between them. I want to add a new parent, and then add a new child for that parent. However, the rows are linked using a foreign key relationship on the parent's auto-increment ID, which won't be generated until I reconnect to the data source and update changes (with a data adapter). Is there any way to link these two rows together before I perform the update?
Secondly, what's the purpose of the DataColumn.AutoIncrement property? If you enable this feature, and ADO.NET generates an auto-increment value on its own while disconnected, isn't there a good chance that this value will conflict with one generated by another disconnected client? Matthew You can read messages from the Advanced DOTNET archive, unsubscribe from Advanced DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
