D
Derek Chong
Hi,
I have a dataset containing a parent and child datatable linked by a foreign
key relationship. When I update the parent datatable primary key field, the
update cascades to all the dependent child records. Problem arises after I
have updated the database with the parent datatable, the foreign key trigger
on the database cascades the change to the child records. When I go to
update the database with the child datatable I get a concurrency error as
the child record Id's have already been changed and the dataadapter cannot
find the original records to change them.
What am I doing wrong? Is there an easier way to update the database with a
multitable dataset?
I have a dataset containing a parent and child datatable linked by a foreign
key relationship. When I update the parent datatable primary key field, the
update cascades to all the dependent child records. Problem arises after I
have updated the database with the parent datatable, the foreign key trigger
on the database cascades the change to the child records. When I go to
update the database with the child datatable I get a concurrency error as
the child record Id's have already been changed and the dataadapter cannot
find the original records to change them.
What am I doing wrong? Is there an easier way to update the database with a
multitable dataset?