Hello,
I have row["TotalArea"].ToString. TotalArea is the decimal field in the SQL Table, and it is 60.0000.
So, in Visual Studio 2003 the above line gives me 60, while in VS 2005 gives me 60.000. Can anyone tell me what's going on Any ideas how to account for those changes
Thank you.
Object.ToString() produces different output in VS 2003 and 2005
Jean-Francois H.
You can force the function to use the precision you desire by passing the format string to the ToString() method.
decValue.ToString("0.000")
This cause the value to be printed such that the whole number to the left of the decimal and 3 places to the right will be displayed. If no whole number exists then a zero is used. If there are not enough decimal places to the right of the decimal then zero is used. If you replace the zeros with # then you can set a maximal precision without trailing zeros. Refer to Format Specifiers in MSDN for a complete list of the options you have available.
As a side note you shouldn't rely on any automatic formatting done by ToString(). MS documents this as a method that can potentially change format options between versions. Always specify the exact formatting string you want if the format output is important to you.
Michael Taylor - 2/13/06