Try using the ResumeBinding method of the CurrencyManager after the update and acceptchanges.
>Cathi,
>
>I have noticed that when I add the new row to the child table the relation get disturbed and also spoiles the databinding !!
>
>As I said befor for updating the data I am using this code
>
>Me.BindingContext(myDS, "Member.MemMsr").EndCurrentEdit()
>myMeasureDA.Update(myDS, "Measure")
>
>- "Member.MemMsr" is the relation
>- "Measure" is the relation
>
>Any suggestions ?
>
>
>>Add the new row to the child table and not the relationship.
>>
>>>Dear All
>>>
>>>What is the correct method when you have a parent table and child tbale and datarelation between them?
>>>Adding the new Row to the child table as :
>>>
>>>myDS.Tables("Member").NewRow()
>>>
>>>
>>>Or adding the new Row to the relation as :
>>>
>>>
>>>myDS.Tables("Member.MemMsr”).NewRow()
>>>
>>>
>>>Thanks for the advice
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi