Grouping datatable column using LINQ in C#
var grouped = from table in dt.AsEnumerable()
group table by new { placeCol = table["Place"] } into groupby
select new
{
Value = groupby.Key,
ColumnValues = groupby
};
foreach (var key in grouped)
{
Console.WriteLine(key.Value.placeCol);
Console.WriteLine("---------------------------");
foreach (var columnValue in key.ColumnValues)
{
Console.WriteLine(columnValue["Name"].ToString());
}
Console.WriteLine();
}
Console.ReadLine();
For additional info:
