如何在VB.NET中从运行的总数据表中求和列?

Question

我目前正在做一个项目，我遇到了一个错误，上面写着:Syntax error in aggregate argument: Expecting a single column argument with possible 'Child' qualifier。我有一个名为Total#"在BusinessAnalytics数据表中。我想把这一列加起来，这样我就可以用它来计算成员的百分比和非成员的百分比。我该如何解决这个问题?

运行总数的数据表代码

Dim decTotalNumber As Decimal
Dim decPercentSales As Decimal
Dim intRow As Integer
If chkRewards.Checked = True Then
intRow = 1 'member
Else
intRow = 0 'nonmember
End If
With BusinessAnalytics.Rows(intRow)
.Item("Total#") += 1
decTotalNumber = BusinessAnalytics.Compute("SUM(Total#)", Nothing)
decPercentSales = Convert.ToDecimal(.Item("Total#")) / decTotalNumber
.Item("%Total") = decPercentSales.ToString("P1")
End With

GridView3.DataSource = BusinessAnalytics
GridView3.DataBind()

Answer 1

列名包含非字母数字字符，因此应该用方括号或" ' "(重音)引号

表达所以你的语句应该是:

decTotalNumber = BusinessAnalytics.Compute("SUM([Total#])", Nothing)