Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DataRelation Prevent my DataSet Updates!!
Message
From
26/02/2003 12:19:33
 
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00758171
Message ID:
00758211
Views:
19
Just a guess, Ahmad, since I haven't used either DataRelations or the da.Update(), but why don't you update the DataSet as opposed to the DataTable. So, you'd do this instead:
da.Update(myDS)
~~Bonnie


>Hi All,
>
>I have 2 datatable in my dataset and have created a datarelation between the parent & child datatables.
>
>If I updated the parent table, the data saved fine, but if updated child table it updates fine (if one row in the relation) but if it has more than one row it egnores the update & does not give any error too. Usig this code:
>
>BindingContext(myDS, "Measure").EndCurrentEdit()
>myMeasureDA.Update(myDS, "Measure")
>myDS.AcceptChanges()
>
>
>It woks fine if I removed the datarelation before the update !!!
>
>
>myDS.Relations.Remove("MemMsr")
>BindingContext(myDS, "Measure").EndCurrentEdit()
>myMeasureDA.Update(myDS, "Measure")
>myDS.AcceptChanges()
>
>But I need the relation, any one knows how to solve this essue.
>
>Note: I am using CommandBuilder, & MSDE as backend database
>
>Thanks for the help
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform