使用LinQ给DataTable排序

string OrderRoom = "desc";

DataTable dt = new FloorCateRoomSystem().getBieShuRoomListSystem(301).Tables[0];

EnumerableRowCollection<DataRow> roomEnumer;
if (OrderRoom == "desc")
{
    var selectedRows = from r in dt.AsEnumerable() orderby r.Field<int>("alias") descending select r;
    roomEnumer = selectedRows;
}
else {
    var selectedRows = from r in dt.AsEnumerable() orderby r.Field<int>("alias") select r;
    roomEnumer = selectedRows;
}
foreach (var item in roomEnumer)
{
    Response.Write(item["name"].ToString() + ", " + item["alias"].ToString() + "</br>");
}

posted on 2010-03-03 13:41  一粒沙  阅读(1657)  评论(0编辑  收藏  举报