By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,815 Members | 1,142 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,815 IT Pros & Developers. It's quick & easy.

DataAdapter.fill Dataset with error: "Input string was not in a correct format"

P: 2
Hi all,
I have a problem when i fill a dataset with a query return via ODBC via Oracle.
The program work well from many month. I think, but I'm not sure, that the problem is the field "Price" that return in a record for the first time value 0,78 (so far it has been always greater than 1).
The code is:
Expand|Select|Wrap|Line Numbers
  1. Dim cmd As New Odbc.OdbcCommand
  2. sql = "SELECT * FROM....
  3. cmd.CommandText = sql
  4. cmd.CommandType = CommandType.Text
  5. cmd.Connection = DB
  6.  
  7.  
  8. Dim da As New Odbc.OdbcDataAdapter
  9. da.FillLoadOption = LoadOption.OverwriteChanges
  10.  
  11. da.SelectCommand = cmd
  12. da.Fill(ds, "TABLE11")
  13.  
Please, can anyone help me? Thanks
Jul 13 '12 #1
Share this Question
Share on Google+
1 Reply


P: 2
Hi,
I have resolved the problem changing the ODBC property "Numeric Setting" from "Use Oracle NLS setting" at "Use Microsoft regional setting".
I hope this post is useful for someone.
Bye ;)
Jul 14 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.