DataTable Column Sum Total

DataTable Column Sum Total

 

DataTable sumDataTable = new DataTable();
sumDataTable.Columns.Add("total", typeof(string));
sumDataTable.Columns.Add("workedhours", typeof(int));
sumDataTable.Columns.Add("tfshours", typeof(int));

DataRow row = sumDataTable.NewRow();
row["total"] = "Total";
row["workedhours"] = oldDataTable.Compute("Sum(workedhours)", "workedhours > 0");
row["tfshours"] = oldDataTable.Compute("Sum(tfshours)", "tfshours > 0");
sumDataTable.Rows.Add(row);

 

 

출처 : https://stackoverflow.com/questions/3396744/how-to-calculatesum-up-an-a-row-value-of-an-datatable