I want to find the instance of each item from one DataTable in another. There will not be duplicates.
Ordinarily I would just use For loops like this:
I know that this is supremely innefficient and that there must be a better way. Can someone show me a faster method?Code:For Each aRow As DataRow In myDataSet.Tables("Table1").Rows For Each bRow As DataRow In myDataSet.Tables("Table2").Rows If bRow.Item(0) = aRow.Item(0) Then ' Found Matching Items End If Next bRow Next aRow




Reply With Quote