I have a DataTable in a DataSet, this DataSet is filled by an Adapter and I intended to Insert new rows to and Delete rows from this DataTable only, and I built my own InsertCommand and DeleteCommand for the adapter (the DataTable is filled from many table sources in the database). However when calling to Update method of the adapter, there is an exception saying that there is no required UpdateCommand for the adapter because there is some DataRow with Modified state, this is true but the strange is the content of the DataRow with Modified state is the same to the original version, in fact I can't find any part of my code which can modify its content and after debugging a little, its content is not really changed (I know this for sure), but why is its state turned to Modified???
Do you know any case in which the DataRow state can be Modified while its content is not really modified?
I think of the DataRow content can be modified at least twice, the first time the content is modified and the second time the content is changed back to the original version. I'll check this case later.
Thank you!
Submit an article or tip