主题：数据分析 求助

Dim cmd As New SQLCommand

cmd.C

cmd.CommandText="sel ect FItemID,FStockID,sum(FQty) as 数量 from ICInventory group by FItemID,FStockID HAVING sum(FQty) > 0 and FStockID < 739"

Dim dt As DataTable = cmd.ExecuteReader

对K3即时库存进行条件取数后获得了一个 数据表 dt

如何 对dt表的 FItemID 进行 数量求和 并将数据写入 tb 表中。

"sel ect FItemID,FStockID,sum(FQty) as 数量 from ICInventory group by FItemID,FStockID HAVING sum(FQty) > 0 and FStockID < 739"

这个语句能修改一下 直接对 FItemID 的 FQty 求和不，条件是 FStockID < 739 即对原数据表中的部份数据进行分组求和。