troubleshooting Question

VB.Net - Comparing Two DataTables

Avatar of Jimbo99999
Jimbo99999Flag for United States of America asked on
.NET ProgrammingVisual Basic.NET
3 Comments2 Solutions68 ViewsLast Modified:
Good Day Experts!

I have 2 lists of AccountNumbers.  I am looking for duplicate product numbers across all the accounts.  Here are my 2 lists and a little summary of what I am doing:

1     1
2     2
4     4    
5     5
6     6

I loop through first list comparing to all in the second list.  Problem I have is...say I find a duplicate in Account 1 and 2...then I also get the same record when on Account 2 and comparing to Account 1.  

Do you have any ideas on hos I can better do this compare to eliminate the extra records?

Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros