expression column doesnt update after deleting a row

[Ramez]

Hello
I have a column its expression is set to "Sum(child.Price)". If I've added a
row to the child table the expression column will be updated correctly.
However the problem arises when I delete a row (from the child table), the
expression column remains unchanged.

Thanks in advance for helping.

 

[Kevin Yu [MSFT]]

Hi Ramez,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that when a row is removed from child table,
the value of the computed column is not updating. If there is any
misunderstanding, please feel free to let me know.

Based on my research, this is a known issue in current version of .NET
Framework. The column with expressions will not recompute value when child
or parent rows are deleted. Here I have a workaround. You can handle the
DataTable.RowDeleted event to re-set the expression for the subtotal column
after setting it to an empty string.

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."