Updating Database from Dataset Datatable
Hello,
I have bound the fields on the form back to the datatables in the dataset. What I am doing is changing a value in a field and then I want to save the changes back to the database. I don't select a different row of data. I am using the dataset.HasChanges() to see if any changes have been made. When I perform the check it doesn't recognize that the field value has been changed and therefore doesn't update the data back to the database. I have added a messagebox to display the value of the field changed and it is displaying the modified value. Can anyone help to explain why the changes aren't being recognized and what I need to do to get them to be so?
Note: If I select a different row of data and then attempt to save the information it works fine. I have also tried using me.bindingcontext("datatable").position +=1 as a suggestion from someone, but it causes an error.
Thanks,
Carey