Jorge L Fernandez

Jorge L Fernandez

  • NA
  • 412
  • 150.6k

The TableDataAdapter.Update() method does not applies the changes to the database

May 17 2007 5:52 AM
Hi developers: I have defined a Typed DataSet by adding a new item (.xsd) to my project. Then I added a TableAdapter with a simple Fill method that retuns a set of data from a simple SELECT query. The Wizard generates successfully the INSERT, UPDATE and DELETE methods but when the dataset is modified at runtime and the TableAdapter.Update() method is invoked nothing happens. I using a BindingSource and a BindingNavigator in order to get an "MS-Access Appearance" while surfing through the data. All bindigs are set correctly and I have check (by debuging) that the RowState Property of the modified rows is set to "DataRowState.Modified". Another thing, when calling the AcceptChanges() method the dataset replaces the new values for the olds values corresponding to the modified rows. WHY ??? Please any suggestion will be appreciated. Thanks in advanced. Jorge Luis.

Answers (1)