Browse by Tags

Datasets with Foreign Keys back to AutoIncrement field no longer working?

I have a dataset with several tables. They all reference back to one row whose key is autoincrement. After creating a new record, everything references an ID of -1, as you would expect from autoincrement. In version 1.0.35.1, when I wrote this dataset out using table adapters using the following SQL...

Posted to Bugs (Forum) by jpwkeeper on 09-23-2011
Re: SQLiteDataAdapter.fill(dataTable) bug

Anyone has this same problem???

Posted to Bugs (Forum) by Cyberguy on 12-17-2010
SQLiteDataAdapter.fill(dataTable) bug

Hi there, I have a function in my application that fills a dataTable with the contents of a table and then export it to XML via dataTable.writexml(). The fields are mainly numerics, but the values in the dataTable are rounded to 0 decimal places when one of the values has no decimal places. Example:...

Posted to Bugs (Forum) by Cyberguy on 12-16-2010
How to convert excel datetimes using tableadapter?

Here's my question: I have an SQLite table containing Excel datetimes e.g. 40057.0069444444 (old OLE format), stored in SQlite db in Double format. Now I want to show them in a TableGridView using a tableadapter. This doesn't work because .net can't convert from Double numbers to the .net...

Posted to General (Forum) by andy2m on 01-30-2010
Re: SQLiteDataAdapter.Fill(datatable)

Leo, I get the same message when using dataAdapter.fill(). While I couldn't solve it properly, i used CREATE TABLE (myDatetimeField TEXT) instead. But it translates time to my timezone (dd/mm/yyyy hh:mm:ss) so i cannot sort on this field. Thus far, i just managed to avoid a program crash What about...

Posted to Bugs (Forum) by Lionel on 08-26-2009
DataAdapter locks Insert?

Good afternoon, i'm using SQLite for .NET in last version, but my problem is (maybe) version invariant. I connect database file using: Dim csb As New SQLite.SQLiteConnectionStringBuilder() csb.JournalMode = SQLiteJournalModeEnum.Persist csb.CacheSize = 1024 csb.DateTimeFormat = SQLiteDateFormats...

Posted to General (Forum) by marektp on 08-21-2009
InvalidOperationException when filling byte[] values into DataTable using DbDataAdapter.Fill

I have problems filling byte[ values into a DataTable from a TEMP table that is created using CREATE TABLE x AS SELECT * FROM y WHERE ... I've found this BUG with1.0.65, later I checked with 1.0.63, but it performs the same. As at my previously posted bug ( http://sqlite.phxsoftware.com/forums/t...

Posted to Bugs (Forum) by BilikTamas on 07-30-2009
DataSet.Load and DataTable.Load - very slow

Lately I've made some performance tests of System.Data.SQLite provider. I've noticed during tests of SELECT command that DataSet.Load and DataTable.Load methods are much slower compared to other methods of reading data (using DbDataReader or with DbDataAdapter.Fill method). I've got following...

Posted to General (Forum) by KoD666 on 10-29-2008

Page 1 of 1 (8 items)