<div>
That isn't garbage, that is how the computer has that number stored in memory. &nbsp;Non integral values are just an '<i>approximate</i>' value
</div>


That isn't garbage, that is how the computer has that number stored in memory.  Non integral values are just an 'approximate' value

<div>
If you really want the details then look here for more info.<br />
<a href="http://en.wikipedia.org/wiki/Floating_point" rel="ugc">http://en.wikipedia.org/wiki/Floating_point</a>
</div>


If you really want the details then look here for more info.
http://en.wikipedia.org/wiki/Floating_point [http://en.wikipedia.org/wiki/Floating_point]

<div>
<div class="content wysiwyg-content">
hi! i am reading a line from a csv file, splitting the line using the split method, and parsing the array, inserting the values into an sql table. one of my fields is defined as type float. i using the following code to convert the string to a float and insert into my field. the float inserted is correct except that it has a lot of garbage added to it. does anyone know why this happens?<br />
<br />
here is the code:<br />
value = splitLine[lineIndex];<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; insertSql.AddFieldValuePai<wbr />r(&quot;VIN&quot;, &quot;@VINParam&quot;);<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Single f = Convert.ToSingle(value);<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (myCommand.Parameters.Inde<wbr />xOf(&quot;@VINP<wbr />aram&quot;) &lt;&nbsp;0)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; myCommand.Parameters.Add(&quot;<wbr />@VINParam&quot;<wbr />, System.Data.SqlDbType.Floa<wbr />t).Value = f;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; myCommand.Parameters[&quot;@VIN<wbr />Param&quot;].Va<wbr />lue = value;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; lineIndex += 1;<br />
<br />
for example, when the float value is: 16.43437<br />
<br />
i get:16.434370040893555
</div>
</div>


hi! i am reading a line from a csv file, splitting the line using the split method, and parsing the array, inserting the values into an sql table. one of my fields is defined as type float. i using the following code to convert the string to a float and insert into my field. the float inserted is correct except that it has a lot of garbage added to it. does anyone know why this happens?

here is the code:
value = splitLine[lineIndex];
            insertSql.AddFieldValuePair("VIN", "@VINParam");
            Single f = Convert.ToSingle(value);
            if (myCommand.Parameters.IndexOf("@VINParam") < 0)
                myCommand.Parameters.Add("@VINParam", System.Data.SqlDbType.Float).Value = f;
            else
                myCommand.Parameters["@VINParam"].Value = value;
            lineIndex += 1;

for example, when the float value is: 16.43437

i get:16.434370040893555

Inserting into Float field in sql table

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).