I am trying to replace SoftwareID (under Title
column) with tblSoftware.Title. Likewise, put tblSoftware.UnitPrice
in this field (temporarily it is showing the value from Quantity
field). Lastly, have a calculated field S. Total
(Quantity * UnitPrice).
If this was a single gridview, I would cycle through the gv and multiply Quantity * UnitPrice values and place it in S. Total. But here the situation is different. We have three nested grid view which makes it a bit complicated.
Question: How to pull Title and UntiPrices from tblSowtware (using EF); and adding S. Total calculated field?
FYI: The project solution (EF_YouTube.zip about 1.1 MB with db file in it is at: https://onedrive.live.com/?cid=420CDD6A13807C9B&id=420CDD6A13807C9B%21116
for additional information. It is developed in vs2012 and uses SQLEXPRESS12)