In a Winforms application I have to log all changes in datagrid (datatable). In other words I want to to get all changes, since it has been loaded. For this I want to use Datatable.GetChanges(). I know, that with GetChanges() I get a datatable containing a copy of all rows in the original DataSet that have pending changes.
My question is now, if it is also possible to get more additional information of the changes. For example I want to know if a row has been added or deleted or only has been updated. If a row has been updated I also want to know which cells has been updated? Is there a way to get all this information quickly or does I have to do a deep comparison row by row with the original datatable?
Or is it better to use RowState to get all changes?