本文介绍了如何获得列“片”的总和在数据表中?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在数据表中获取列碎片的总和?说我有下表。如何计算article =milk和artno =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());
}
抱歉,我是新的DataBase开发人员,我的英文说语言不是很好。
Sorry, but i'm new DataBase developer and my english speak language is not so good.
推荐答案
使用方法,您可以执行以下操作:
Using the DataTable.Compute
method, you can do:
int sum = (int)table.Compute("Sum(pieces)", "article = 'milk' AND artno='15'");
这篇关于如何获得列“片”的总和在数据表中?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!