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();

 

posted @ 2017-04-03 16:17  茗::流  阅读(119)  评论(0)    收藏  举报
如有雷同,纯属参考。如有侵犯你的版权,请联系我。