Save expression column in database
-
Hi, thanks for looking Im having a problem with my dataset I have an Orders table and a details table I want to save the total of the order in the orders table My dataset has the same exact structure as my db tables Orders: OrderID Total Details: DetailID OrderID ProductID Price When i try to save (using tableadaptermanager) im having problems At first, i would get an error saying "The column mapping from SourceColumn 'Total' failed because the DataColumn 'Total' is a computed column.", So i removed the expression column before saving But now, a 0.00 is being saved in the Total column in the DB The best solution i see is removing the expression and iterate throug the orders table and recalculate the total manually Any suggestions?? (Besides doing it manually :) Thanks in advance
Alexei Rodriguez