![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| 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. |
| |||||||
![]() |
| |
| | #1 (permalink) |
| | 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 Specs![]() |
| | #2 (permalink) |
| | Re: foreign key update in Tableadapter dataset I figured. I had to edit the relation and select cascade options. |
My System Specs![]() |
![]() |
| 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 | |||