1
Answer

Return a money value from a stored procedure to C#

Jean

Jean

16y
3k
1

I have a stored procedure which sums 2 values from tables,  adds the 2 values together then passes the sum back to the C# program which called it.  The output parameter is defined as @insBalTransfer money

This is how I am receiving the value:

decimal insBalTransfer=(decimal)DBCmd.Parameters["@InsBalTransfer"].Value;

The actual calculated value is 27.14.  What I get is 27.  How do I define this so I get the decimal places

Answers (1)