This is very odd because I can see that both of the datarows contain the correct value when I check in Debug mode, it just isn't updating the database.i have two questions: 1) What am I missing that is causing the script not to work?Once this is done, I update the Data Set via a Data Adaptor such that these tables are transferred to the SQL database. As far as I can see, the values in the primary key of A and the corresponding keys in B will not necessarily be the same in the Data Set and the SQL database! I can't see how the relationship specified is still valid after the Update. Thanks in advance Geoff You would have to create custom Update commands in your Data Adapter to handle any concurrency issues.
HTH -- Dale Preston MCAD C# MCSE, MCDBA "Geoff" wrote: Hi I'm hoping somebody can help me with the following problem that has occurred to me.
As far as I can see, adding (updating) entries in both tables of the SQL database create, NOT NECESSARILY THE SAME, values in the ID_A field e.g.
what if another user has added rows during the time the disconnected data has been modified.
Data Reader Data Reader is used to read the data from database and it is a read and forward only connection oriented architecture during fetch the data from database.
Data Reader will fetch the data very fast when compared with dataset.
You might like some of the heated debate on the subject on my blog at