If i understand you well, you need to join data on
id
, then to compare
weight
s:
DataTable Datatable3 = (from a in Datatable1.AsEnumerable()
join b in Datatable2.AsEnumerable() on a.id equals b.id
select new{
Id = a.id,
Name = a.Name,
Weight = a.Weight
Result = a.Weight == b.Weight ? "x" : ""
}).CopyToDataTable();
[EDIT]
Ok, try something like this:
var qry = from a in dt1.AsEnumerable() join b in dt2.AsEnumerable() on a.Field<int>("id") equals b.Field<int>("id")
select new
{
Id = a.Field<int>("id"),
Name = a.Field<string>("Name"),
Weight = a.Field<int>("Weight"),
Result = a.Field<int>("Weight") == b.Field<int>("Weight") ? "x" : ""
};
foreach(var v in qry)
{
Console.WriteLine ("{0} {1} {2} {3}", v.Id, v.Name, v.Weight, v.Result );
}