DataTable to LINQ
DataTable dt = ds.Tables["TAccounts"]; var list1 = ( from a in dt.AsEnumerable() where a.Field<int>("FCompayId") == 36052 select new { FID = a.Field<int>("FID"), FAccout = a.Field<string>("FAccout"), FCompanyId = a.Field<int>("FCompanyId") } ).ToArray(); var list2 = dt.AsEnumerable() .Where(a => a.Field<int>("FCompanyId") == 36052) .Select(a => new { FID = a.Field<int>("FID"), FAccout = a.Field<string>("FAccout"), FCompanyId = a.Field<int>("FCompanyId") }).ToArray();

浙公网安备 33010602011771号