Selecting distinct records from DataTable with OrderBy
DataTable distinctTable = dt.AsEnumerable()
.GroupBy(r => r.Field<string>("RequestID"))
.Select(g => g.First())
.OrderByDescending(r => r.Field<string>("RequestID"))
.CopyToDataTable();
Comments