C# - Merge two DataTables where rows are duplicate

Question

I can find lots of information about merging two DataTables and dropping duplicate rows, but I need the opposite.

I need to know if anyone has an easy way to merge two DataTables where the result of the merge is a DataTable with only rows that exist in both tables.

SLaks · Accepted Answer · 2011-07-26T17:01:56.433

4

Like this:

var intersection = table1.AsEnumerable()
                         .Intersect(table2.AsEnumerable(), DataRowComparer.Default);

DataRowComparer compares rows by their column values.

edited Jul 26 '11 at 17:01

answered Jul 26 '11 at 16:38

SLaks

868,454
176
1,908
1,964

1

but OP wants "the result of the merge is a DataTable"? – naveen Jul 26 '11 at 16:40
@naveen: Then call `CopyToDataTable()`. – SLaks Jul 26 '11 at 16:43
@bemused: yes. msdn also use `.Default` http://msdn.microsoft.com/en-us/library/bb386998.aspx. i dont think there is a `DataComparer.Instance` – naveen Jul 26 '11 at 16:51

C# - Merge two DataTables where rows are duplicate

1 Answers1

Linked