DataColumn.Expression Power

Question

the following code

Dim dc = New DataColumn(name, GetType(Double), "[col1] ^ [col2]")

produces the following error:

The expression contains unsupported operator '^'.

Is this right, is the power operand not support in datacolumn expressions???

Anyone have an idea how i'd write this?

Answer 1

Yes. it is not supported.

You could use RowChanging event of DataTable to set the value of the new column using c#.