Browse by Tags

SqLiteDataAdapter issues

Hi, I've got some things I don't understand and have a rather large post to explain the issues. When I use sql server my code looks like this: private static void Save( DataSet someDataSet ) { using( TransactionScope scope = new TransactionScope( TransactionScopeOption.Required ) ) { using( SqlConnection...

Posted to General (Forum) by SilentBob on 01-03-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
Memory leak in SQLiteDataAdapter?

I had a problem with memory leaking when using SQLiteDataAdapter. To reproduce, run code like this in a loop and watch the program's memory grow: Dim sql As String = "Select * from TableName limit 1" Using targetTable As New DataTable Using adapter As New SQLiteDataAdapter(sql, connection...

Posted to Bugs (Forum) by GertG on 09-16-2010
SQLiteDataAdapter.Fill Select from view

hello, I have a problem with SQLiteDataAdapter.Fill when I select some data from view. code: sqlString = @" SELECT Sprzet_ID,Grupa,NrRejestrowy,Nazwa,Stan_ID FROM Sprzet_view; "; DataSet ds = new DataSet(); SQLiteDataAdapter da = new SQLiteDataAdapter(sqlString, DBConnection); da.Fill(ds);...

Posted to General (Forum) by slepiec on 08-19-2010
Re: SQLiteCommand.ExecuteNonQuery() consuming memory

Using Cache Size=10 had a small effect. The program has been modified to use ADO .Net a bit more intelligently. Here's the function that does the writing: public void WriteData(int key, double value) { string dateString = DateTime.Now.ToUniversalTime().ToString("s"); // Remove the 'T'...

Posted to General (Forum) by Interrobang on 04-27-2010
SQLiteDataAdapter.Update returns 0 (does not insert data into the database)

Hi everybody! I've been trying to implement a CSV insert with a little trick: I use the OleDb CSV parser to fill my SQLiteDataSet, then I want to use the SQLiteDataSet to update the SQLite database. Unfortunately I've been stuck on this one problem- when I call Update on the SQLiteDataAdapter...

Posted to General (Forum) by lirik on 04-26-2010
X64 Could not load file or assembly 'System.Data.SQLite' or one of its dependencies. An attempt was made to load a program with an incorrect format

" Could not load file or assembly 'System.Data.SQLite' or one of its dependencies. An attempt was made to load a program with an incorrect format." The above error i m getting on the runtime. application with same dll is working fine on 32 bit version of OS. but when i got 64 bit version...

Posted to Bugs (Forum) by rajesh on 02-15-2010
SQLiteDataAdapter.Fill(datatable)

Hi everyone i have a problem with the sqlite data adapter when i try to execute fill() method for filling the datatable; when querying the DateTime column in table where that column is NULL. I get the following exception: String was not recognized as a valid DateTime. i found somewhere that...

Posted to Bugs (Forum) by leo_Mostar on 11-21-2008
SELECT / GROUP BY / ORDER BY Issue.... ?

I'm writing a Media Management application, and thought everything was working smoothly until I had to update my media player to make use of alternative data views, and it started breaking when the correct number of tracks for a particular playlist appeared to be incorrect. I've attached the...

Posted to Bugs (Forum) by VorTechS on 10-10-2008

Page 1 of 1 (10 items)