[Mono-list] SqlDBType.Money processed wrong with mono 2.6.4

Jacek Rużyczka stacheldraht at interia.pl
Sun Jun 13 05:37:22 EDT 2010


Am Sonntag 13 Juni 2010 10:59:35 schrieb Josef Semmler:
> Hi,
> i'm either doing someing stupid - or there is a bug with handling
> SqlDBType.Money in mono 2.6.4 ... please help me.
> I have a sqlserver 2005 -  in a table with an attribute "Amount" of type
> "Money" i try to store different values, which are in the c# code
> represented as "decimal" - for any reason, the values are stored completly
> wrong.
I would suppose that MONEY is a fixed-point data type, which means that the 
decimal point is always two positions left of the last digit. This is why your 
code stores values like 144.568 incorrectly.

I suppose that when you round (use the System.Math.Round() method) the decimal 
values to two digits, your code will work.

Kind regards
Jacek Rużyczka

Wakacyjna przygoda czeka! Zgarnij nagrody za 18 000zl!
Sprawdz >>> http://linkint.pl/f2721

More information about the Mono-list mailing list