I wasn't sure of the best place to post this (Visual C# general or here) so hopefully I've chosen correctly :).
I would like to write an application that performs a visual diff of 2
DataTables. Let's call them source and destination. There are several
components to this that I would like to solicit opinions on.
I have written something that kind of works but I'm sure there are better
ways to do this. My application is a form that contains 2 DataGridViews, one tied to the source DataTable and the other tied to the destination DataTable.
My end goal is to have records that appear in destination but not in source show with a red background color, records that appear in source but not in destination show with a green background color and rows that have a difference in a field show up yellow (only
the changed cell).
The user should then be able to select which source rows then want to propagate to the destination and which rows in the destination that should be deleted so that they match. Those changes will be applied by generating a .SQL file containing the necessary
One important thing to note is that these DataTable objects will be populated from XML files. This application will not have access to the back-end database directly or at the very least it will only have access to one of them but never
View Complete Post