Update Gridview - from 2 different source
<p>I have a gridview connected to SQL DB via a Objectdatasorce.</p>

<p>I first insert a record with data collected from textboxes.</p>

<p>On update, user enters 2 fields on the gridview - MarketValue &amp; PercentAllocated. 
These 2 values effect a field OperatingCost, which needs at least 10 other textbox inputs to calculate.</p>

<p>Is there a way I can intercept the Gridview Update Command &amp; grab the 2 values the user entered (MarketValue &amp; PercentAllocated) &amp; calculate the OperatingCost &amp; update the 3 values (MarketValue &amp; PercentAllocated &amp; OperatingCost) at one shot?</p>
