Dim nf As String = "2020"
Dim dtg As DataTable = DataTables("工资明细")
Dim FT As String = "项目 = \'实发工资\' and 发放 = 1"
Dim zj As Double = dtg.SQLCompute ("Sum(值)",FT & "and 年 = \'" & nf & "\'")
Dim ys As Integer = dtg.SQLCompute("Count(*)",FT & "and 年 = \'" & nf & "\'")
Output.Show(zj)
错误提示:操作数数据类型 nvarchar 对于 sum 运算符无效。
因为值里会有名字,我需要如何统计?