NEED storedproc for calculating totalcost

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