Browse by Tags

Install Error

hi, i'm having some trouble in the instalation, could somebody help me? when i install the "SQLite-1.0.66.0-setup" file, there is this message: " an unhandled exception ('System.ArgumentException') occurred in install.exe [3108]" and then the installation is aborted. what...

Posted to General (Forum) by Guilherme on 08-13-2010
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
Is CF2.0+ SQLite a viable future solution?

My question is how to use it, but is this solution going to be available in the future? I'm in the process of upgrading a Physical Inventory system that uses Motorola/Symbol WinCE scanners. The older version utilized AccessCE. It is not a viable candidate anymore. I do not want the same state in...

Posted to General (Forum) by mhoop81 on 06-14-2010
Rebuild assemblies with a different name and SQLITE_DLL for side by side x86/x64 ?

Hello, I am trying to use SQLite.NET in both 32 AND 64 bits environments, in a scenario where I cannot force my process in 32 bit (must run in 64 bit native), and where the deployment is xcopy-based (same files, no way to choose during install time between the two versions, and no way of knowing before...

Posted to General (Forum) by Krzys on 11-04-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
LINQ generating inappropriate SQL???

I am trying to use LINQ with System.Data.SQLite (version 1.0.64.0) in VS2008 (no SP), and am unable to insert a row into a table. The code below generates the error I am seeing. Besides the two columns that appear in the code and log, there is one more named CustomerKey which is the integer primary key...

Posted to General (Forum) by Steve Reynolds on 07-23-2009
SQLite Exception "Unable to open the database file"

Dear all, As first really thanks for all the helps you are providing. If possible I have a little question, but please, consider me an absolute beginner. I'm tryng to develop a little test application for smart device using C# and SQLite. After the creation of the DB and the related schema, if I...

Posted to General (Forum) by Giovanni on 07-01-2009
Re: Readin Blob data in C#

But consider this line: long len = rdr.GetBytes(1, 0, null, 0, 0); it throws a Cast Exception, Check: http://sqlite.phxsoftware.com/forums/t/1781.aspx Any suggestion there?

Posted to General (Forum) by afshin on 06-19-2009
Re: Readin Blob data in C#

Thanks to Joel Lucsy It has been fixed. Here is his code: public T GetValue<T>( String query ) { using (IDbCommand cmd = connection.CreateCommand()) { cmd.CommandText = query; return (T)cmd.ExecuteScalar(); } } public void foo() { byte[ img = GetValue<byte[>( "select imageblob from imagetable"...

Posted to General (Forum) by afshin on 06-18-2009
Readin Blob data in C#

Hi, I'm using the latest Wrapper, Installed about a week ago. I try to use SQLiteDataReader to read a file from the database and write it to a file, but the problem is I can't read it, I either get Cast Exception or No Current Row. For No Current row, if i use reader.Read(); Then I get CAST Exception...

Posted to General (Forum) by afshin on 06-17-2009

Page 1 of 2 (16 items) 1 2 Next >