采用Linq语句对数据进行分组,通过创建新的DataTable达到分组求和的目的。
DataTable dtGroupBy1 = dtSeletedRows.AsEnumerable().GroupBy(r => new { customerno = r["customerno"] }).Select(
g =>
{
var row = dtSeletedRows.NewRow();
row["customerno"] = g.Key.customerno;
row["barcodeQty"] = g.Sum(r => Convert.ToInt32(r["barcodeQty"]));
return row;
}).CopyToDataTable();