I'am having a problem regading the computation in sql. I been using C# and am creating a web application. All i want is to multipy the value of the record from one table and multipled it with the other table.
s oi caome up with this idea.
SELECT A.CODE, A.COST, (A.AMOUNT * @MARKUP)AMOUNT
FROM PRICE_TABLE A
INNER JOIN Rate_Type B
ON A.CODE = B.CODE
WHERE B.MARKUP = @MARKUP
i already place it in the gridview. all i want is, when the click the record on the grid. the modalpopupextender will popup. but this time the computed value is already define..