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

C# DATA TABLE

Answers (2)