hi guys,
I am using Column properties in SQL Server 2005. I was all ready assisted with this in SQL and it works fine. Now I need to get it to work in a Visual Basic 2008 Data-Grid. I don’t necessarily need general help with “Add new data source” => Database => Connection String => Choose Table => Finish. I don’t claim to be a pro, but I have created many Datasets and they all work fine in Visual Basic 2008 Standard edition. This Dataset “InventoriDataSet.xsd” looks fine after debug, and has no errors until you try to add a record. There are two records in it that were created in SQL, and all fields look good. My problem is that I can not create any new records in the Visual Basic program, although I can in SQL.
The Culprit: 1 column that has a formula. which is simply multiplying two columns. This works fine in SQL, but not in a VB 2008 Data Grid.
1) Column name: TotalPrice - The formula => ([quantity]+[price])
The update fails and the error message is:
The column”TotalPrice” can not be modified because it is either a computed column or is the result of a UNION operator.
any ideas?