DataTable Compute Method

Question

Compute is one of the methods of DataTable class. This method computes an expression on the current rows that pass the filter criteria.

 

Syntax

Object DataTable.Compute(string expression , string filter)

 

Expression - The expression to compute.

Filter - The filter to limit the rows that evaluate in the expression.

 

This method's return type is System.Object. So, you have to cast it with appropriate data type.

 

The following operations can be passed through as expression parameter.

Sum -> Sum

Average -> Avg

Minimum -> Min

Maximum -> Max

Count -> Count

Statistical standard deviation ->StDev

Statistical variance -> Var

Eliza