我正在生成一個餅圖，當前有以下變量，如何排除空記錄？它可以工作，但餅圖中包含空值var PieChartData1 = from T1 in Result group T1 by T1.Reasons into G1 orderby count ascending select new { G1.Key, Count = G1.Count() }; obj.peichart1 = PieChartData1.ToArray();
3 回答
慕田峪4524236
TA貢獻1875條經驗 獲得超5個贊
如果T1是可空的，則使用HasValue屬性
var PieChartData1 = from T1 in Result
where T1.HasValue
group T1 by T1.Reasons into G1
orderby count ascending
select new { G1.Key, Count = G1.Count() };
蕭十郎
TA貢獻1815條經驗 獲得超13個贊
您也可以使用lambda表達式編寫它：
var pieChartData = Result.Where(r => r.Reason != null)
.GroupBy(r => r.Reason)
.OrderBy(g => g.Count())
.Select(g => new { g.Key, Count = g.Count() });
- 3 回答
- 0 關注
- 222 瀏覽
添加回答
舉報
0/150
提交
取消