Browse by Tags

.Net 4.0 & SQLite 1007000 sample

I created a .net 4.0 WinForm appi with SQLite embedded and want to share the source code.. So here it is [ MyBlog ] [ Code Project ] So have fun and enjoy...

Posted to How To (Forum) by Kribo on 05-02-2011
Re: VS2010 Pro & SQLite 3.6.23.1

You not only need to add System.Data.SQLite to your References, but you either need to include the following using clause at the top of the file... using System.Data.SQLite; ... or, you need to fully qualify SQLiteCommand as System.Data.SQLite.SQLiteCommand. If you use it repeatedly in a source file...

Posted to How To (Forum) by ericp on 03-02-2011
Insufficient parameters error when using GridView control (with DataKeyNames and DataSourceID specified)

I have a problem that I'm guessing has at least something to do with the ASP.NET control life-cycle. I have a GridView control to allow editing of certain records in an SQLite db. I have gotten what I thought to be pretty much the same thing to work on a different page on my site that accesses a...

Posted to General (Forum) by robg37 on 07-01-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
SQLiteCommand.ExecuteNonQuery() consuming memory

Greetings! I have a Windows service whose purpose is to write a new row to a small table (three columns) in each of 124 SQLite databases once a minute. The service's memory allocation grows slowly over time, at a rate of about two megabytes an hour. Since, like all services, my service is designed...

Posted to General (Forum) by Interrobang on 04-23-2010
Parallelitätsverletzung : The UpdateCommand ..."

Hello, I get with the following program code always the error message "(in German): Parallelitätsverletzung : Der UpdateCommand hat sich auf 0 der erwarteten 1 Datensätze ausgewirkt.". try { string sPath = "WindowsFormsApplication1\\"; string SQLDataBase = "testdb.db3";...

Posted to General (Forum) by Dietmar Immenhausen on 09-26-2009
Database file isn't copying over?

I'm playing around a bit with trying to get a sqlite database to open and display in a mobile application, and I'm having some trouble getting it going. From what I can tell, the file isn't being copied like it's supposed to. When I go into file explorer on the simulator, there is a file...

Posted to General (Forum) by andyd273 on 09-14-2009
Setting SQLiteCommand.Connection

Hi, Is there any associated problems by reusing SQLiteCommand objects by setting its Connection property? I imagine something like the following: // In the main thread: SQLiteConnection connA = ... SQLiteCommand cmdA = connA.CreateCommand(...); // In some other thread: SQLiteConnection connB = connA...

Posted to General (Forum) by yngve on 08-20-2009

Page 1 of 1 (8 items)