Browse by Tags

Re: strange Error : no such table : ....

The same error occurs in the following situation too: You add .db file to your project. Then when you run your c# project with debugger, empty db. file is copied into bin/debug folder of the project folder. Your running application looks for tables in the empty database and returns error: "no such...

Posted to General (Forum) by sevenkul on 08-19-2011
Re: How to Insert Blob Image to SQLite in C#

Hi there, After reading the forum ran into your question and decided to take it up as a small project and thus writing an article. I created a WinForm appi based on C# - .NET4.0 - System.Data.SQLite 1007000 (.net provider) with an embedded SQLite database. And I want to share the source code.. So here...

Posted to How To (Forum) by Kribo on 05-15-2011
.net 4.0 support?

I wanted to convert a couple of my projects using the provider to 4.0 to use some new features, but when I did so, the ctor of my ObjectContext subclass started failing with: System.ArgumentException: The specified store provider cannot be found in the configuration, or is not valid. I'm assuming...

Posted to Feature Requests (Forum) by jamesmanning on 04-18-2010
Questions from novice getting aquainted with sqlite

Hi, I have decided to rewrite an Access db I wrote several years ago into C# using system.data.sqlite. Other than the Access db and its light VBA coding, my only experience is a C++ class I took a few years ago in college. So, I'm really a beginner, and will have to learn as I go. I came here to...

Posted to General (Forum) by hamyer on 03-15-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
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 3 (21 items) 1 2 3 Next >