For my example:
Code:
mydataset.GetChanges(); //returns also rows with DataRowState.Unchanged mytable1TableAdapter.Update(mydataset.mytable1); //also child's rows are modified to DataRowState.Unchanged, so they will not be updated!!!
x5Rb
Last Activity: Oct 28 '07, 12:25 PM
Joined: Oct 19 '07
Location:
-
I am here again, my QAD doesn't work. ADO.NET is crap.
For my example:
-
OK, let it be, I solved it QAD (quick and dirty):
1. PKs of all tables in client-side: autoincrement step=-1, autoincrement seed=-1
2. PKs of all tables in DB: autoincrement step=1, autoincrement seed=1
3. after dataset's Merge I look up and delete all rows with negative primary keysLeave a comment:
-
DB (on the server) is correctly updated.
Maybe I didn't write it clearly, but:
1. I can't simply use dataadapter method to not violate (server-side) FK constraint.
2. If I use dataset's getchanges+data adpater's update+dataset' s merge it doesn't merge added rows correctly (client-side has 2 copies of the same row with different primary key values).
I could simply reload all data after update but that's what...Leave a comment:
-
Thanks, you're right, but I can't edit it.
BTW: if you have any suggestions, post it, please.Leave a comment:
-
Problem with saving changes of DataSet to database with relations
Database: 2 parent tables + 1 child table (child of both parent tables), enforcing foreign key constraints
App: winformsapp, stuff (dataset, datatables, tableadatpers) generated by designer
Thanks constraints (server's database) I must save changes in this order:
1. If I'm adding rows:
a) add parents rows
b) then add child rows
2. If I'm removing rows:
a) add child rows...
No activity results to display
Leave a comment: