Data table excel

i have 2 data table
both contain name n age coloumn
we have some common name n age values in both tables
now what to do if i want only values of table 1 that are not in 2nd table

dt1.AsEnumerable.Intersect( dt2.AsEnumerable(),system.Data.DataRowComparer.Default).CopyToDataTable

try this or go with join tables

i want non matching values. USING THIS I WILL GET COMMON values

you use except instead of intersect