表结构如下:
Lamda表达式:
List<News> model = NewsService.GetNewsAllList(null, whereCriteria, null);//获得数据
if (model != null)//数据不为空时,分组并排序
{
var ls = model.GroupBy(a => a.PublishDw).Select(g => (new
{
name = g.Key,
count = g.Count()
})).OrderByDescending(c => c.count);
Repeater1.DataSource = ls;
Repeater1.DataBind();
}
结果: