DataTable dt = new DataTable();
dt = GetDataSource();
var codeQuery =
    from code in dt.AsEnumerable()
    group code by code["group"] into g
    orderby g.Key
    select g;
foreach (var item in codeQuery)
{
    Response.Write(item.Key + "
");
    foreach (var d in item)
    {
        Response.Write("***" + d["value"] + " " + d["text"] + " " + d["display"] + " " + d["group"] + " " + "
");
    }
}
分組資料group 子句 (C# 參考)
LINQ: How to get the latest/last record with a group by clause
C#: Left outer joins with LINQ
利用LINQ GroupBy快速分組歸類
 
 
沒有留言:
張貼留言