从C#中的DataColumn值获取总和

using System.Linq;

// 假设dataTable是一个DataTable对象，columnName是要求和的列名
int sum = dataTable.AsEnumerable().Sum(row => row.Field<int>(columnName));

int sum = 0;
foreach (DataRow row in dataTable.Rows)
{
    sum += row.Field<int>(columnName);
}

DataColumn sumColumn = new DataColumn("Sum", typeof(int), "SUM(" + columnName + ")");
dataTable.Columns.Add(sumColumn);
int sum = (int)dataTable.Rows[0][sumColumn];