Author: sargamlucy | Posted on: 11/10/2010 5:34:05 AM | Views : 306

Hi All,
Is their a quick way to compare two datatables, to see if there is any change in the data.
My datatables may contain huge data, so i do not want to loop through it.
I tried the following code, but it is not working even if the data in dt1 and dt2 are same.
Private Function CompareDataTable(ByVal dt1 As DataTable, ByVal dt2 As DataTable) As DataTable dt1.Merge(dt2) Dim d3 As DataTable = dt2.GetChanges() Return d3 End Function
So, would somebody plz tell me, how could I compare two datatables.
Regards,
Snigdha 
...

Go to the complete details ...