本文介绍了如何使用LINQ创建总计列和总计行?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
给出一个没有总计列或行的数据表.如何使用LINQ添加总计列"和总计行"以创建下表?
Given a datatable that does not have a total column or row. How can I use LINQ to add a Total Column and Total row to create the table below?
TextColumn, NumberColumn0, NumberColumn1 Total A 1 4 5 B 2 55 47 C 2.3 DBNULL 2.3 D 4 3 7 Total 9.3 62 61.3谢谢!
嗯,对于那些需要代码的人.我目前正在使用此列作为总计列:
Um, for those who need code. I'm using this currently for total column:
public static void CreateTotalColumnByType(DataTable table, Type valueType) { // create expression string expression = string.Empty; // do not count the first column (used for string field) for (int columnIndex = 1; columnIndex < table.Columns.Count; ++columnIndex) { if (columnIndex != table.Columns.Count - 1) { // add + expression += String.Format("[{0}] + ", table.Columns[columnIndex].ColumnName); } else { // last column so don't add plus expression += String.Format("[{0}]", table.Columns[columnIndex].ColumnName); } } // add total column DataColumn totalColumn = new DataColumn("Total", valueType, expression); table.Columns.Add(totalColumn); }但是我想用LINQ代替它.
but I'd like to replace it with LINQ.
推荐答案//adds Total column var q1 = src.Select(x=>new { x.TextColumn ,x.NumberColumn0 ,x.NumberColumn1 ,Total=x.NumberColumn0+x.NumberColumn1}); //adds Totals row var q2 = q1.Concat(new[]{new{ TextColumn="Total" ,NumberColumn0 = src.Sum(_=>_.NumberColumn0) ,NumberColumn1 = src.Sum(_=>_.NumberColumn1) ,Total=q1.Sum(_=>_.Total)}});
更多推荐
如何使用LINQ创建总计列和总计行?
发布评论