我怎样才能为列"总和;&件QUOT;在一个DataTable? [英] How can I get a sum for the column "pieces" in a datatable?
本文介绍了我怎样才能为列"总和;&件QUOT;在一个DataTable?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我怎样才能在一个DataTable列片的款项?说我下面的表格了。我该如何计算的文章=奶和货号=15总片?
How can I get a sum for the column "pieces" in a datatable? Say I had the following table. How can I calculate the "total" pieces for article="milk" and artno="15"?
Columns: article artno pieces
Rows:
1 milk 15 1
2 water 12 1
3 apple 13 2
4 milk 15 1
5 milk 16 1
6 bread 11 2
7 milk 16 4
的
我的新DataTable的结果应该是这样的:
The Result of the my new DataTable should be this:
Columns: article artno pieces
Rows:
1 bread 11 2
2 water 12 1
3 apple 13 2
4 milk 15 2
5 milk 16 5
我的代码:
foreach (DataRow foundDataRow in foundRows1)
{
int i = 0;
foreach (DataRow dataRow in foundRows2)
{
if (object.Equals(dataRow.ItemArray[0], foundDataRow.ItemArray[0])
&& object.Equals(dataRow.ItemArray[3], foundDataRow.ItemArray[3]))
{
i = i + Convert.ToInt16(dataRow.ItemArray[4]);
}
}
Debug.Print(i.ToString());
}
很抱歉,但我是新数据库开发人员,我的英语会说的语言是不是那么好了。
Sorry, but i'm new DataBase developer and my english speak language is not so good.
推荐答案
使用的 DataTable.Compute
方法,你可以这样做:
Using the DataTable.Compute
method, you can do:
int sum = (int)table.Compute("Sum(pieces)", "article = 'milk' AND artno='15'");
这篇关于我怎样才能为列"总和;&件QUOT;在一个DataTable?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文