Framework 1.0 and 1.1 differs in conversion of decimals to strings

12 Jan 2005 12:55 PM

Johan Lachonius

Lets say i have a decimal value i the database e.g. 20.35. The field in the
database has a scale of 3. When I read this value into a DataSet and the
convert it to a string using ToString() the result is different depending on
if I'm using Framework 1.0 or 1.1. In 1.0 the result is 20.35 which is fine,
but in framework 1.1 the result is 20.350. What I have figured out is that
the behaviour of converting a System.Decimal to a string has changed in
framework 1.1. As we are upgrading a pretty big application from framework
1.0 to 1.1 this is quite a problem for us.

Does anyone know how to get back the old behaviour in framework 1.1, that is
if you have saved a decimal value of 20.35, that will be the value you get
after doing a ToString() without formatting info? We could use other
overridden methods of ToString but the problem is that we are also getting
xml from the dataset and it seems that the default ToString method is used
there as well to convert decimals to xml text, hence the same promblem
occurs.

Johan

12 Jan 2005 3:02 PM

Philip Q [MVP]

I think this is a bug in 1.0 that they fixed in 1.1, as it is now correctly
interpreting the scale property. Try adjusting the scale to 2 - you can do
this either in the database, if you are using output parameters, you might
be able to set this by using setting the SqlParameter.Scale property.

--
Philip Q
Microsoft MVP [ASP.NET]

Show quote

"Johan Lachonius" <JohanLachon***@discussions.microsoft.com> wrote in
message news:524657A3-7A8B-44F7-B9DE-C24483C06EF4@microsoft.com...
> Lets say i have a decimal value i the database e.g. 20.35. The field in
> the
> database has a scale of 3. When I read this value into a DataSet and the
> convert it to a string using ToString() the result is different depending
> on
> if I'm using Framework 1.0 or 1.1. In 1.0 the result is 20.35 which is
> fine,
> but in framework 1.1 the result is 20.350. What I have figured out is that
> the behaviour of converting a System.Decimal to a string has changed in
> framework 1.1. As we are upgrading a pretty big application from framework
> 1.0 to 1.1 this is quite a problem for us.
>
> Does anyone know how to get back the old behaviour in framework 1.1, that
> is
> if you have saved a decimal value of 20.35, that will be the value you get
> after doing a ToString() without formatting info? We could use other
> overridden methods of ToString but the problem is that we are also getting
> xml from the dataset and it seems that the default ToString method is used
> there as well to convert decimals to xml text, hence the same promblem
> occurs.
>
> Johan