C# DATA TABLE

Question

how to comapare two datatable row and diffrence in another table.in c#.NET

Rajeesh Menoth · Answer

Hi Check this following example : http://www.dotnetperls.com/datatable-compare-rows

Venkateshwar Reddy · Answer

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; } }