I'm having a strange problem which I can't seem to work out the reason for. I have a series of columns of which one is calculated. When I go to save the values (be it a new row or an update), the field which the calculated column is linked with does not get updated.
My code for creating the calculated column is as follows:
GridViewDecimalColumn col =
col.MaxWidth = 90;
col.MinWidth = 90;
col.Width = 90;
col.FormatInfo = CultureInfo.CreateSpecificCulture(
"IsNull(Ink, 0) + IsNull(PB_Products, 0) + IsNull(Office_Supplies, 0) + IsNull(Freight, 0)"
For the Save Button, I'm using TableAdapter.Update()
Where abouts have I gone wrong?