in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine
All Tags » sql query (RSS)

Browse by Tags

  • 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

  • System.Data.ConstraintException

    Hi Guys, This is my first time using SQLite and I've run into an issue. I've got a SQLlite Database keeping a list of people and associated cost centres, it's pretty basic: Two tables, both with an ID column which is unique, autoincrement and primary key. Some other various columns, name...
    Posted to General (Forum) by turkeywelder on 01-25-2010

  • reading and writing BLOB fields in chunks

    Hi everyone. I have a database that stores large music files as BLOB fields. The problem is that the .net provider loads the entire BLOB field into memory which causes my application to to use too much memory (and eventually crash). Is there a way to tune the .net provider so that I can load and...
    Posted to General (Forum) by liron on 05-23-2009

  • View Indexes Used in Queries

    I have an application that's driven off of SQLite. It has many indexes for each table many of them seem to be used well but sometimes a simple query can lock up my app for a very long time. Usually in the order of minutes. Is there a way to see what indexes for a particular query SQLite decides to...
    Posted to General (Forum) by jeremyje on 10-25-2008

  • no refresh on dialog box while using multi-threaded DataReader on large database.

    Hello, I precise that i read Robert's post speaking about SQLite Provider in multi-thread environnement. I am programming with the compact framework under WinCE 5.0. What i do is very classic. I have an DialogBox (A) to search a user in the database (about 67 000 records in database). After the user...
    Posted to General (Forum) by m3z on 10-22-2008

  • C#, .NET CF 2.0 - The changes are not saved on database.

    The scenario: Application developed with Visual Studio 2005, C#, .NET CF 2.0, SQLite, Windows CE 5. The problem. The user search for a register in database, runs OK, the user change a information in the register and save it. The user make a new search for that register, and the new information is ok...
    Posted to General (Forum) by acidbytes on 06-04-2008

  • ORDER BY ROWID not quite what I expected

    Hi, I've been getting on really well with the SQLite data provider over the last couple of weeks, but have now run into a problem. I have a process creating a new table, dumping data into that table (INSERT INTO - SELECT FROM multiple tables) and displaying that data. A subsequent process then adds...
    Posted to General (Forum) by VorTechS on 05-19-2008

  • Join on two tables

    Hi. I just started using System.Data.SQLite and really like it. I do however have some trouble with a to me simple query. I have three tables, tblArtist, tblAlbum, tblTrack I guess you can figure out the relations yourself ;) Now I want to select 1 album with it's artist and tracks, so I use the...
    Posted to General (Forum) by ZNS on 09-14-2007
Page 1 of 1 (8 items)
Powered by Community Server (Commercial Edition), by Telligent Systems