问题描述
XML：-<expense>-<user><username>CCC</username><category>Automobile</category><amount>123</amount><expenseDate>02/15/2012</expenseDate></user>-<user><username>AAA</username><category>Employeebenefits</category><amount>1.2</amount><expenseDate>02/23/2012</expenseDate></user>-<user><username>BBB</username><category>Adverting</category><amount>123</amount><expenseDate>01/02/2012</expenseDate></user>-<user><username>AAA</username><category>Adverting</category><amount>123</amount><expenseDate>07/05/2011</expenseDate></user>-<user><username>BBB</username><category>Commissions&Fees</category><amount>123123</amount><expenseDate>12/23/2011</expenseDate></user>-</expense>用LINQ需要输出结果时orderbycategory（这个我会）,并且不显示重复的用户名（这个我可以实现），但是需要在中间将相同用户的合计金额插入（我就不知道了）结果像这样：先谢谢大家了！！！！！
解决方案
本帖最后由 xufeng52 于 2012-02-28 22:10:07 编辑
解决方案二：
那就循环判断，遇到下一个用户名时，newRow，然后插入datagridview，然后再接着循环。