C# - linq 操作 DataTable

方法一:更简洁
            Console.WriteLine(dt.Rows.OfType<DataRow>().First(x => x.Field<string>("xx_Name") == "A").Field<string>("xx_NO"));   
  
方法二：linq 更清晰
  
            var query = from dr in dt.AsEnumerable()  
                              where dr.Field<string>("xx_Name") == "A"  
                              select dr;  
            Console.WriteLine(query.First().Field<string>("xx_NO"));
 
通过linq对现有的DataTable进行查询,并将结果拷贝至新的DataTable中
// Query the SalesOrderHeader table for orders placed 
// after August 8, 2001.
IEnumerable<DataRow> query =
    from order in orders.AsEnumerable()
    where order.Field<DateTime>("OrderDate") > new DateTime(2001, 8, 1)
    select order;
 
// Create a table from the query.
DataTable boundTable = query.CopyToDataTable<DataRow>();