Thank u Cathi,
But I having this error,
"Error #5, Concurrency Violation:..."
and this happen when I add the new row then update my DS then try to modify it again!
I this I should Re-Fresh or Re-Fill the DS, if yes, that means I should do the Re-Fill after each add, delete or modify operation I do?
And will this code do the job:
' Update DataSet
Me.BindingContext(myDS, "Area").EndCurrentEdit()
myDA.Update(myDS, "Area")
myDS.AcceptChanges()
' Re-Fresh DataSet
myDS.Clear()
myDA.Fill(myDS, "TableName")
Thanks again
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>