C# DATA TABLE

Please refer the below snippet.

DataTable Datatable3 = dt1.AsEnumerable().Union(dt2.AsEnumerable())

.GroupBy(x => x.Field("Id"))

.Select(x =>

{

var topWeightItem = x.OrderByDescending(z => z.Field ("Weight")).First();

return new Items

{

Id = x.Key,

Name = topWeightItem.Field("Name"),

Weight = topWeightItem.Field("Weight"),

DataTable1 = dt1.AsEnumerable().Any(z => z.Field("Id") == x.Key

&& z.Field("Weight") == topWeightItem.Field("Weight")

&& z.Field("Name") == topWeightItem.Field("Name"))

? "X" : String.Empty,

DataTable2 = dt2.AsEnumerable().Any(z => z.Field("Id") == x.Key

&& z.Field("Weight") == topWeightItem.Field("Weight")

&& z.Field("Name") == topWeightItem.Field("Name"))

? "X" : String.Empty

};

}

).PropertiesToDataTable();

I have used following type for conversion purpose:-

public class Items

{

public int Id { get; set; }

public string Name { get; set; }

public decimal Weight { get; set; }

public string DataTable1 { get; set; }

public string DataTable2 { get; set; }

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.