#2 Handling of strings

closed
nobody
None
5
2004-01-23
2004-01-15
Alain Maillot
No

Using Finisar.SQLite dataprovider build 0.6.

I've been trying to fill a dataset with a simple query
(select * from tblCategories) and am getting the
following error on the DataAdapter.Fill(Dataset) call:

"An unhandled exception of
type 'System.FormatException' occured in
system.data.dll

Additional information: Input string was not in a correct
format"

Not quite sure why this is happening, but it seems to
work fine if I select none-string columns from the
database.

Just one more quick note, I thought it may have
something to do with my code but I took the sample
TestGUI application, renamed my database and created
a copy of the table I'm trying to use (its got 2 columns,
one integer, one string, both not null) and set its name
to mytable (as is used by the application). Running the
compiled application caused a runtime error.

Discussion

  • Tim McDaniel
    Tim McDaniel
    2004-01-23

    • status: open --> closed