Changes to an SDF database file are never saved

Question

Whenever I do restart the application, changes to a DataTable are never saved in the SDF database file.

Example :

_table.Clear();
_adapter.Update(_table);

Or

_table.Clear();
_adapter.Update(_dataSet);

I also tried the following but without success :

Thank you.

Ok, without knowing what `_table` is, any reason why you are clearing it before saving it? — Adam Houldsworth, Apr 24 '12 at 14:20
I am making some tests, this is why. And _table is the table I have added rows to. — aybe, Apr 24 '12 at 14:28
In that case nothing is updating because you have flushed your table of any rows before calling update. — Adam Houldsworth, Apr 24 '12 at 14:29

score 1 · Accepted Answer · answered Apr 24 '12 at 14:24

Are you attempting to delete all rows from the database?

DataTable.Clear clears all the rows from the table:

It doesn't mark them for deletion, which is what you would need to do to remove them on an update:

1 Answers1