¿¿help in column expression :((

  • Thread starter Thread starter perspolis
  • Start date Start date
P

perspolis

hi everyone
I have a table in Sql that have 2 columns name qunatity and Unitprice;
In my application I create an additional column name Total and set it's
ColumnExpression just to show quantity*UnitPrice and in sqlDataAdoptor's
commands
I just update the first 2columns(mean quantity and UnitPrice)
but unfortunately when use SqlDataAdoptor.Update method to update
DataTable,it gives me the followinf error "Cannot change ReadOnly property
for the expression column" :(
I don't know why??
becuase Total column just show a computed column and dosen't have any impact
on my DataTable.
plz help me
 
hi Perspolis
may be there is something missing here . the update method of the data
adaptor is meats to update the datesouce ( means here your SQL table ) .
what are the parameters that you pass to the update method.
Mohamed M .Mahfouz
Developer Support Engineer
ITWorx on behalf of Microsoft EMEA GTSC
 
I passed just those field in mt table mean Quantity and UnitPrice.
If I remove ColumnExoression property from Total column,it wroks correctly.
 
Back
Top