LCK bataimuihong LCK bank LCK bank LCK bank KHNGOAI bank KHNGOAI bataimuihong KHNGOAI bataimuihong
how can i count the number of occurrences after grouped by 'khoa' and 'tenban'
<pre>var data = (from a in _en.EMR_BenhAn.Where(p => p.NgayLap >= tungay && p.NgayLap <= denngay).ToList() join dmba in _en.DM_BenhAn on a.KyHieuBA equals dmba.KyHieuBA join kh in _en.EMR_Khoa on a.MaBAn equals kh.MaBAn join kp in _en.KPhongs on kh.MaKPnh equals kp.MaKP select new { kp.TenKP, dmba.TenBenhAn }).GroupBy(p => new { p.TenBenhAn, p.TenKP }).ToList(); var data2 = data.Select(p=> new { TenBenhAn = p.Key.TenBenhAn, TenKP = p.Key.TenKP }).OrderBy(p=> p.TenKP).ToList(); var sl = data.Select(p => p.Key.TenBenhAn); xrSL.Text = sl.ToString();
.GroupBy( p => new { p.TenBenhAn, p.TenKP }, (key, items) => new { key.TenBenhAn, key.TenKP, Count = items.Count() })
ToString
List<T>
sl.ToString()
System.Collections.Generic.List`1[System.Boolean]
xrSL.Text = string.Join(", ", sl);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)