double/float insert into mssql

[Jan Agermose]

Im writing a small test app that reads stringvalues, parses them to
doubles and inserts the doubles into a mssql database. But the values
inserted are not the same as the original string values?

I tried paring the values using one of the two linies:

double vekselkurs =
double.Parse(no de.Attributes["rate"].Value.Replace( ".", ","));

//double vekselkurs = double.Parse(no de.Attributes["rate"].Value, new
System.Globaliz ation.CultureIn fo("en-US"));

And adding the value as an argument to my SP using

paramater = new SqlParameter("@ vekselkurs", SqlDbType.Float );
paramater.Value = vekselkurs;
command.Paramet ers.Add(paramat er);

The values I read are:

743.27
617.23
1133.12
81.25
88.69
8.52
492.10
....

The values as seen from the database querytool:

743.26999999999 998
617.23000000000 002
1133.1199999999 999
81.25
88.689999999999 998
8.5199999999999 996
492.10000000000 002
....

Why is that? I tryed using float in my c# code but that makes matters worse.

Regards
Jan

[Jon Skeet [C# MVP]]

Jan Agermose <ja@conviator.c om> wrote:

Im writing a small test app that reads stringvalues, parses them to
doubles and inserts the doubles into a mssql database. But the values
inserted are not the same as the original string values?

See http://www.pobox.com/~skeet/csharp/floatingpoint.html

You might want to consider using decimal instead.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too