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.
– Renatas M., Commented Apr 5, 2012 at 13:27
here is the info you seek stackoverflow.com/questions/6075067/… — krystan honour
– krystan honour, Commented Apr 5, 2012 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
– Damien_The_Unbeliever, Commented Apr 5, 2012 at 13:31

Joshua Drake · Accepted Answer · 2012-04-05 13:35:16Z

4

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

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

See the SQLMoney Constructor documentation.

answered Apr 5, 2012 at 13:29

Joshua Drake

2,7563 gold badges36 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:11:26Z

1

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

CommunityBot

11 silver badge

answered Apr 5, 2012 at 13:29

phadaphunk

13.4k17 gold badges76 silver badges109 bronze badges