I have a stored proc that returns a decimal in the form of an out parameter. (See code below). I'm using SQL server 2005. I read this out paramter in a C# method as a Decimal in C#. (See code below) I'm using VS 2008. The problem is that the value being read it is an Int. Some how my decimal is getting converted to an int. I've stpeed through the code and varified that the value in the paramter is an int. is there some reason i should not be able to use and out paramter to get my data?
Thanks,
Wiz
Code snippets
Stored proc --
ALTER
PROCEDURE [dbo].[Get_Receipts_For_ShipCredit_Sum]
@Begin_Date
datetime,
@End_Date
datetime,
@Country_Code
varchar(5),
@Part_System
varchar(10),
@Amount
decimal(18,6) out
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT @Amount = SUM(Extended_Cost)
FROM dbo.MR_Receipts
WHERE Country_Code = @Country_Code
AND Receipt_Status <> 0
AND ITRN_HIS_DATE BETWEEN @Begin_Date AND @End_Date
AND Part_System = @Part_System
END
C# code snippets
Here's my declared variable
SqlParameter
amount = new SqlParameter("@Amount", SqlDbType.Decimal);
Here's the method that gets the value.
private
static void GetAmount(string cnnString, SqlCommand command, SqlParameter amount, MrxReportOutObject mrxOutObj)
{
using (SqlConnection connection = new SqlConnection(cnnString))
{
command.Connection = connection;
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
if (amount.Value == DBNull.Value)
{
mrxOutObj.Amount = 0;
}
else
{
mrxOutObj.Amount =
Convert.ToDecimal(amount.Value);
}
reader.Close();
reader.Dispose();
}
connection.Close();
connection.Dispose();
}
}
Wiz
