in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine
All Tags » C# » vs2008 (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

  • 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

  • sqlite Exception System.InvalidCastException: Specified cast is not valid.

    This is the Code in C#: SQLiteDataReader rdr; SQLiteCommand contentCommand; String cmd = String.Format("SELECT filename,content,filesize FROM documents WHERE did={0}",120); contentCommand = sqlconn.CreateCommand(); contentCommand.CommandText = cmd; rdr = contentCommand.ExecuteReader(); rdr...
    Posted to General (Forum) by afshin on 06-17-2009

  • SQLite error: no such table: tblLogin

    Dear all, I am coding the SMS Management Application for my Pocket PC Windows Mobile 6.1 and use SQLite. I created db3 file and tables by Visual Studio 2008. I drap and drop tables from Server Explorer to Dataset Designer. I also edited connection string in dataset source code and copy SQLite.Interop...
    Posted to General (Forum) by tavu on 02-11-2009
Page 1 of 1 (8 items)
Powered by Community Server (Commercial Edition), by Telligent Systems