Browse by Tags

Basic help - select query result...

Hi, I'm a newbiz in sqlite (and in C#)... and I try to find an answer on google and this fourm before posting. Since some months (when I have time) I try to learn C#. I give myself a goal to learn the language : write a text gui game, I was thinking that a database would be too heavy to manipulate...

Posted to How To (Forum) by nicodevil on 03-08-2010
A single step solution to avoid Deadlock in Multi-threading

n its simplest form, deadlock occurs when each of two (minimun two) threads try to acquire a lock on a resource already locked by another. E.g: Take example of two threads 1. thread 1 2. Thread 2 And two resources 1. Resource 1 2. Resource 2 Thread 1 locked on Resources 1 and tries to acquire a lock...

Posted to General (Forum) by elizas on 02-19-2010
parameterized queries With Jocker

hello guys. i want to talk you about a problem that i got it.. i dont know how i could to write some parameterized query with a joker like "%". maybe im doing it in the right way cuze usually i do it in another database environments but i dont know what is the reason for it is not working....

Posted to How To (Forum) by mijaelstand on 02-14-2010
error in dll or visual studio? is this a bug or what?

from this link http://sqlite.phxsoftware.com/forums/p/2209/8934.aspx#8934 i found the problem of my project i got a Can't find PInvoke DLL 'SQLite.Interop.065.DLL error when i insert images in the imagelist toolbox. I prefer to use imagelist than inserting images in the database because its easier...

Posted to General (Forum) by amw403 on 02-11-2010
Can't find PInvoke DLL 'SQLite.Interop.065.DLL - Bug?

Few days ago i can execute my program in a mobile device and emulator without any problem. But now i have the following error Can't find PInvoke DLL 'SQLite.Interop.065.DLL when i execute it in a mobile device but i can execute my program in an emulator (windows mobile 5 ppc r2 emulator) and...

Posted to General (Forum) by amw403 on 02-09-2010
exception is unhandled

private void GetImage() { SQLiteConnection sqlite_con = new SQLiteConnection("Data Source=|DataDirectory|dbasedict.s3db;Version=3;New=False;Compress=True;"); String querry2 = "select id, word, iimages from dictionario where word = '" + searchBox.Text + "'"; SQLiteDataAdapter...

Posted to How To (Forum) by amw403 on 02-07-2010
Re: Reading blob for pocket pc 5, c#, .net cf 3.5

I try this code private void GetImage(string fullName) { SQLiteConnection sqlite_con = new SQLiteConnection("Data Source=|DataDirectory|dbasedict.s3db;Version=3;New=False;Compress=True;"); String querry2 = "select iimages from dictionario where word = '" + searchBox.Text + "'";...

Posted to How To (Forum) by amw403 on 02-02-2010
Reading blob for pocket pc 5, c#, .net cf 3.5

i develop a mobile dictionary(ppc 5) with pictures i've searched this site and i found this thread: http://sqlite.phxsoftware.com/forums/t/1684.aspx the problem is that it gives me error because i think that some of the syntax(like fromstream and memomystream) is not supported in windows mobile any...

Posted to How To (Forum) by amw403 on 02-02-2010
How to retrieve the last autoincremented ID from a table when using a typed dataset?

[Noob alert!] I constructed a typed dataset inside VS 2008. I am using the prefabricated datadapters to fill and update its tables. How can I retrieve the last autoincremented ID from a table? I understand that in SQL it is:Select last_insert_rowid(). But how do I call this SQL from C# ADO.Net? Thanks...

Posted to How To (Forum) by aner on 01-25-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

Page 1 of 4 (37 items) 1 2 3 4 Next >