Well, looking at your code:
According to the
MSDN[
^]:
AcceptChanges() Commits all the changes made to this table since the last time AcceptChanges was called.
When AcceptChanges is called, any DataRow object still in edit mode successfully ends its edits. The DataRowState also changes: all Added and Modified rows become Unchanged, and Deleted rows are removed.
The AcceptChanges method is generally called on a DataTable after you attempt to update the DataSet using the DbDataAdapter.Update method.
Meaning, your
actual data is unaffected in the database. You're just updating the data in the datatable. If you want this change in the database, you need to write the
update statement
for that particular record.
-KR