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.
@MARKUP decimal(18,2) 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..