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

[Jacek Rużyczka]

Hi,

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