Good morning everyone,
I'm having problems when I convert the SQL Server datatype smallmoney to
the .net datatype decimal. I am doing this to pass a dollor amount to
the Verisign payment gateway. Verisign requires that the amount passed
in is in the format ###.##, so if I have 250.50 its passed in exactly as
that. What is happening is that when I use 250.50 the decimal datatype
drops the last zero making this 250.5 which causes the gateway to return
an error stating that I used an incorrect amount. Does anyone have an
idea how I might fix this?
Thanks,
Aaron