Question Computed Column cannot be modified

[Sollyk]

I used Sql Server to design table with some computed columns and it worked but when i drag it to my form in vb.net(DataGridView) from my datasource it fails to update and gave me the following SqlException:
{"The column "Total" cannot be modified because it is either a computed column or is the result of a UNION operator.

Pls help me what do i have to do ?

 

[jmcilhinney]

You would need to remove any computed column(s) from the SQL code in the InsertCommand and UpdateCommand of your TableAdapter(s).

 

[Sollyk]

Thank you jmcilhinney, I sincerely appretiate ur help.

I'm very new in Vb.net

I did what you said i shd do but the question is this, How can i store my computed values into the database because i'm working on student's result database that will only accept their scores in CA and Exam. The total score, Percentage and grade should be calculated and store in the database by the program(Just like the way it's being done in excel). so that student report sheet can printed when needed.
Pls, help me.
Thanks in anticipation

 

[jmcilhinney]

You don;t have to store them in the database. That's the whole point of the computed column. The database column computes the values from other columns.