PicAction action = new PicAction();
IQueryable<PicDetail> list = action.GetUserIdPic(userId);
var q = from a in list
group a by a.key into m
select new
{
key= m.Key,
count = m.Count()
};
DataTable t= new DataTable();
t.Columns.Add("key", typeof(Int32));
t.Columns.Add("count", typeof(Int32));
foreach (var item in q)
{
t.Rows.Add(new object[] { item.key,item.count });
}
string s = (from a in t.AsEnumerable()
where a.Field<int>("key") == 2
select a).First()["count"].ToString();
return Content(s);
LING 分组统计查询、存为DataTable、查询DataTable
最新推荐文章于 2022-04-19 22:44:26 发布