Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > .NET General

Vista - foreign key update in Tableadapter dataset

Reply
 
Old 05-23-2008   #1 (permalink)
Sreekanth


 
 

foreign key update in Tableadapter dataset

I have a dataset with TableAdapter A and TableAdapter B. B has a
foreign key which refer backs to A.

I add a row to table A and then add several rows to Table B. I update
ID of table A of table B with newly added key of Table A (-1)

When I update table adapter A to the database, I get a new value for
ID from database.

But it is not automatically updating references made in Table B.
Shouldn't the new value of Table A automatically propogate to all the
rows in Table B? Or, do I need to update every row of table B with new
ID?

Thanks

My System SpecsSystem Spec
Old 05-23-2008   #2 (permalink)
Sreekanth


 
 

Re: foreign key update in Tableadapter dataset

I figured. I had to edit the relation and select cascade options.
My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
DataSet object VB Script
dataset does not clear .NET General
tableadapter. Loosing newly added state of child tables .NET General
DataSet Designer .NET General


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46