Compare two DataTables

[harvid]

Hi,

In my project i need to compare two datatables which two would contain more than 2 lakhs of record. How do i compare these two efficiently without consuming much time.
Need very urgent,
Thanx in advance,
Vidhya

 

[jmcilhinney]

First off, what's a "lakh". Secondly, what exactly about the two tables do you want to compare? Do you want to know if they have exactly the same data, the same number rows, the same data in a oarticular column, etc.? We need a bit more to go on.