station max_temp min_temp date XYZ 14.5 3.5 26-5-2016 XYX 13.5 3.5 25-5-2016 ABC 14.5 3.5 26-5-2016 ABC 12.5 5.5 23.5.2016
XYZ 14.5 3.5 26-5-2016 ABC 14.5 3.6 26.5.2016
DataView dv = new DataView(dtExtraRowOfXML); dv.Sort = "DateTime DESC"; var x = (from r in dtExtraRowOfXML.AsEnumerable() select r["Station"]).Distinct(); DataTable dtfinalXML = dt1.AsEnumerable().Union(dtExtraRowOfXML.AsEnumerable(), DataRowComparer.Default).CopyToDataTable();
DataTable dtfinalXML = dt1.AsEnumerable() .GroupBy(r => r.Field<string>("station"), (key, rows) => rows.OrderByDescending(r => r.Field<DateTime>("date")).First()) .CopyToDataTable();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)