Posted on: 4/22/2015 1:02:25 PM | Views : 602

Hi All,
  Ok so I have an SQL DB that has a "FLOAT" value in a column of 0.026800000000000001.  When I call this data via a simple Select * into my class using a DataReader, DataSet or DataTable the value gets truncated to 0.0268.  I've tried converting it to a string in the SQL statement, I tried using reader.GetDouble(x) and I've tried casting it and converting in SQL to various types and I can't seem to get the entire value.  Can someone please help?  I've done this in Oracle many times where I set the precision to x amount of places and it works just fine.  I tried to implement that same logic for SQL DataReader but .SetPrecision does not exist. 
Your help is greatly appreciated...

Go to the complete details ...