[已解决问题] linq to sql 怎么实现动态排序？
提问时间: 2008-03-22 09:14
浏览:455 次
比如我把LINQ TO SQL 获取的结果集绑定到ListView,然后点击ListView的某一列来排序。怎么实现？
所有回答(2)
|
这个例子是说使用动态查询，查询London的顾客并按ContactName排序，关于ListView控件使用参看MSDN，希望对你有帮助。
ParameterExpression param = Expression.Parameter(typeof(Customer), "c"); Expression left = Expression.Property(param, typeof (Customer).GetProperty("City")); Expression right = Expression.Constant("London"); Expression filter = Expression.Equal(left, right); Expression pred = Expression.Lambda(filter, param); IQueryable custs = db.Customers; Expression expr = Expression.Call(typeof(Queryable), "Where", new Type[] { typeof(Customer) }, Expression.Constant(custs), pred); expr = Expression.Call(typeof(Queryable), "OrderBy", new Type[] { typeof(Customer), typeof(string) }, custs.Expression, Expression.Lambda(Expression.Property(param, "ContactName"), param)); IQueryable<Customer> query = db.Customers.AsQueryable(). Provider.CreateQuery<Customer>(expr); 楼上的好复杂，你可以这样写 var q= from p in db.products select p; switch(orderyname){ case "id": q= q.OrderBy(t=>t.id); //或者q= q.OrderByDescending(t=>t.id)//倒序 break; case "name" q= q.OrderBy(t=>t.name); //或者q= q.OrderByDescending(t=>t.name)//倒序 break; } |
评论
|
3个月前 FrancisLiu : 谢谢啦， 还是有点晕。我再继续研究 |