Updating DataTable with calculated column

L

Luca Giusti

Hi all,

i've a problem trying to update a DataTable with a
calculated column added at runtime. The error i receive
is:

Cannot change readonly property for the expression column

The only way to avoid this, is to delete the SELECT
statement added by the DataAdapter wizard to the
UpdateCommand SQL string.

Alas, i need this select to know the primary key assigned
by SQL Server (this key will be foreign key for other
entities).

Any of you got any idea?

Thanx you very much,

Luca Giusti
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updating Identity Column in datatable 1
sqldataadapter, datacolumn rowstate 1
Saving Master-Detail bound form - primary key is identity column 2
Updating a column in a DataTable... 2
How to insert rows into tables with Autonumber PKey by using DataSet and DataAdapter? 11
Refresh a datatable afer an update so that child foreignkeys will be changed if necessary 2
Adding row to DataTable which has Sql Server identity column type 4
Dynamic SQL generation - How do I set the key column information manually? 2

Top