|Title:||Data Rounding Issue with SQLiteDataAdapter (secondary issue)|
|Last Modified:||2014-07-18 19:18:35|
|Version Found In:||220.127.116.11|
anonymous added on 2014-07-18 15:40:10:
This is somewhat related to the issue found at ticket #52816622f3, but there are a couple differences. My sample project reads and inserts data from a table to a copy table. When the first value inserted is an Int64, the following values are also inserted as Int64 even if they're being passed in as Doubles. But if the first value inserted is a Double, then the rest are treated as Doubles and I don't lose any precision.
mistachkin added on 2014-07-18 19:18:19:
Please change your code to do this: insertCommand.Parameters.ResetDbType(); insertCommand.Parameters.Value = reader.GetValue(0); insertCommand.Parameters.ResetDbType(); insertCommand.Parameters.Value = reader.GetValue(1);