C# DataTable AsEnumerable Sum, Count Linq쿼리

 

 

 int sumvalue = Result_Table.AsEnumerable().Sum(x => x.Field<int>(Result_Table.Columns[i].ColumnName))

int count = dataTable.AsEnumerable()
               .Count(row => row.Field<string>("Column-A") == "Y"
                          || row.Field<string>("Column-A") == "N");

 

출처: c# - Linq query to count field in datatable - Stack Overflow