careysc

careysc

  • NA
  • 1
  • 0

Updating Database from Dataset Datatable

Jan 5 2005 12:22 PM
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