SQLDataAdapter and computed SQLColumn
Posted on 2006-06-27
I have the following issue:
I have a SQL-Server 2000
I have a Table with a computed column (interestValue which calculates interestRate * value)
I'm using databinding on a winform
I'm using the sqlDataAdapter with CommandBuilder
I want to add a new row to the datatable
I want to save these row to the database
My problem is:
I cannot save this row to the database because the sqldataadapter says that computed columns are not updateable. That's quite correct. How can I tell my datatable that he sould not save/change my computed column?
I think the failure is that, when I add a new row to the datatable, the computed table gets a default value.