I have an application where I load 2 reports from a database each into its own list view box.
I need to be able to compair the two reports and show the differences found in the 2nd report.
How I show the differences is not important at this time.
What would be the best/most efficient way of doing this?
Should I load each listitem from each listview into the dictionary object and compair them that way?
or would it be better to do an Instr vbCompare while loading the 2nd listview?
I am open to suggestions.
I need what will be the most efficient way as some of the reports can have over 1000 rows.