i got a table
PRODUCTMASTER PRODUCTID COMPANYID NAME UNITS COST TOTAL
NEED A STOREPROC OR FUNCTION FOR CALCULATING TOTALCOST..WHEN I ENTER UNITS AND COST AS INPUTS..TOTAL SHOULD BE REFLECTED IMMED..
I HAVE WRITTEN STOREDPROC LIKE THIS:
CREATE PROC [dbo].[PRDTOTAL](@UNITS INT, @COST DECIMAL(5,2)) AS BEGIN
DECLARE @TOTAL AS NUMERIC(38,0)
SET @TOTAL =@UNITS*@COST
PRINT
@TOTAL
END
GO
NEED ASP.NET CODE FOR THE SAME