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 ...