Reason:
This error is caused by missing UPDATE command for sqlDataAdapter.
See the MSDN documentation, for the SqlDataAdapter, You need to pass four
commands SqlCommand object, which also has the connecton object which
connects to your database, SELECT, INSERT, UPDATE, DELETE. to your data
adapter object, inorder to update PHYSICALLY into your database, otherwise,
with dataset AcceptChanges, changes will be made only in the DataSet, when
you quit the application these changes be loss. Read the MSDN documentation
about updation dataset, and the data adapter. (http://bytes.com/topic/c-sharp/answers/252767-dataset-update)
Solutions:
Re-configure Table Adapter.