Syntax Error in aggregate parameters: a single column parameter that requires a possible "Child" qualifier.

DataTable has a method object Compute (string expression, string filter) to calculate the expression given on the current row used to pass filtering conditions.

Expression: the expression to be calculated.

Filter: the filter that limits the rows to be computed in the expression.

Tested:

1. The expression parameter cannot start with a number. Otherwise, an error is returned.

2. The data type of fields in the expression parameter. For example, sum (character type) reports an error.

Solution:

After. NET maps the data table to the memory, the oracle specification cannot be used to check this error. The MSSQL specification should be used. MSSQL uses brackets to forcibly convert field names or table names.

Modify the code to: dt. Compute ("Sum ([February])", "") use [] for forced conversion.

From Zhu jintuo's column