1
Reply

Return a money value from a stored procedure to C#

Jean

Jean

Apr 8 2008 3:25 PM
2.9k

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)