1、把数据从数据读出来,比如说填充到DataTable(假使变量名是DT)
2、linq查询
var result=from r in DT.AsEnumerable()
orderby CreateTime descending
select new{name,CreateTime};
2、linq查询
var result=from r in DT.AsEnumerable()
orderby CreateTime descending
select new{name,CreateTime};
var query =
A.Join(
B.GroupBy(x => x.aid).Select(x => new { x.Key, CreateTime = x.Max(y => y.CreateTime) }),
a => a.id,
b => b.Key,
(a, b) => new { a.name, b.CreateTime }).ToList();