mardi 27 mai 2014

Shortest way to merge DataTables and remove all duplicate rows


Vote count:

0




At first i would like to say that i know there are many examples with merging and duplicates but i couldnt find an exact answer to my question. Currently im getting results that i want (using loops) but i was just wondering if it can be done using LINQ or maybe other (shorter) way.


Following are the items in first table:


table1


...and second table:


table2


What i would like to achieve is to compare values in two columns in these tables: Column A and Column C and get rows from second table (with additional value of column B in first table) which are not duplicated in first table. So in this particular case.. something like that:


enter image description here



asked 1 min ago






Aucun commentaire:

Enregistrer un commentaire