datatable linq

var query = from a in MasterDataHelper.OrganizationTree.AsEnumerable()                                    where                                    a.Field<string>("ID") == dr["Company"].ToString()                                    && a.Field<string>("Type") == "C"                                    select a;                        if (query != null)                        {                            DataTable dt = query.AsDataView().ToTable();                            if (dt.Rows.Count > 0)                                dr["Company"] = dt.Rows[0]["Name"];                        }

上面是筛选代码

var order = from a in dtCompanyStatistics.AsEnumerable()                         orderby a.Field<int>("Num") descending                         select a;            dtCompanyStatistics = order.AsDataView().ToTable();

上面是排序代码