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

Question

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.

Answer 1

Hi coders. I have discovered my problem but are appears another very related doubt. I recreated the database directly into the Management Studio, not by adding a New Item to my project, the rest was the same and the changes were comitted and seved to the database. Here the upcoming doubt: Why the TableAdapter.Update method works when the database is residing on the server and not locally in my project? This problem is related with the created instance of the local database at runtime? Thanks Jorge L.