C# Decimal to SQL Server Money

Question

I have a SQL Server SPROC that takes a money paramater.

I'm passing in a C# decimal to this SPROC

How do I pass in the decimal from C# to the money type in the SPROC in such a way that I wont loose any values after the point

how do you passing decimal value to sproc? Parameter with type Money? — Renatas M., Apr 05 '12 at 13:27
here is the info you seek http://stackoverflow.com/questions/6075067/two-decimal-places-for-decimal-money-field — krystan honour, Apr 05 '12 at 13:28
"Won't lose any values after the point" - if you have any values after the 4th, you're doomed, since money has a fixed scale of 4. — Damien_The_Unbeliever, Apr 05 '12 at 13:31

Joshua Drake · Answer 1 · 2012-04-05T13:35:16.410

4

Just initialize the Parameter with a new SqlMoney(decimal) constructor.

SqlParameter parameter = new SqlParameter("@Money", SqlDbType.Money);

See the SQLMoney Constructor documentation.

edited Apr 05 '12 at 13:35

answered Apr 05 '12 at 13:29

Joshua Drake

score 1 · Answer 2 · edited May 23 '17 at 12:11

1

Or you can look into the .Parse overrides. I know theres a lot of format and currency is one of them.

edited May 23 '17 at 12:11

Community

answered Apr 05 '12 at 13:29

phadaphunk

2 Answers2