.net中的多数据表总和 [英] Sum multi datatable in .net

问题描述

您好所有访客
如何汇总数据集中的多个数据表?
我有1个数据集，在1个数据集中，我有4个数据表.
我想对每个数据表的每一列求和.
我该怎么办?

此致

dataset1.datatable1.sum("sum(colum1)"，string.empty)
dataset1.datatable2.sum("sum(colum1)"，string.empty)
dataset1.datatable3.sum("sum(colum1)"，string.empty)
dataset1.datatable4.sum("sum(colum1)"，string.empty)
尝试这样的事情！

文本框中的摘要:

dim d1 as ineger
dim d2 as integer 
dim d3 as inrteger
dim d4 as integer

d1=dataset1.datatable1.sum("sum(colum1)",string.empty) 
d2=dataset1.datatable2.sum("su(colum1)",string.empty)
d3=dataset1.datatable3.sum("sum(colum1)",string.empty)
d4=dataset1.datatable4.sum("sum(colum1)",string.empty)

me.textbox1.text=d1+d2+d3+d4

Hi all visitors
How can i sum multi datatables in dataset?
i have 1 dataset and in 1 dataset i have 4 datatables.
i want to sum each column of each datatable.
How can i do that?

Best Regards,

解决方案

dataset1.datatable1.sum("sum(colum1)",string.empty)
dataset1.datatable2.sum("sum(colum1)",string.empty)
dataset1.datatable3.sum("sum(colum1)",string.empty)
dataset1.datatable4.sum("sum(colum1)",string.empty)
try something like this!

sumary in text box:

dim d1 as ineger
dim d2 as integer 
dim d3 as inrteger
dim d4 as integer

d1=dataset1.datatable1.sum("sum(colum1)",string.empty) 
d2=dataset1.datatable2.sum("su(colum1)",string.empty)
d3=dataset1.datatable3.sum("sum(colum1)",string.empty)
d4=dataset1.datatable4.sum("sum(colum1)",string.empty)

me.textbox1.text=d1+d2+d3+d4

这篇关于.net中的多数据表总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！