需求如下,DataTable为查出学生表成绩,按成绩排序取出前5条,网上看了些例子,用到Take(5),但只能用在IList<T>里。我的写法是
var query = from t in dt.AsEnumerable()
orderby t.Field<Int32>("score")
select t;
接着怎么去前5条呢?
var query = from t in dt.AsEnumerable()
orderby t.Field<Int32>("score")
select t;
接着怎么去前5条呢?
orderby t.Field<Int32>("score")
select t).Take(5);
只要继承IEnumerable都可以Take
orderby t.Field<Int32>("score")
select t).Take(5);
orderby t.Field<Int32>("score")
select t).Take(5);
//取5到10
var d=q.Take(10).Skip(5);
where t.Field<string>("isindoor")=="室外"
orderby t.Field<decimal>("utility_rate")
select t).Take(5);