in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine
All Tags » c# » Blob (RSS)

Browse by Tags

  • 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

  • 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

  • Reading Blob data from a table

    I have a SQLite table with a blob data. I would like to do the following, but it doesn't work: String con = String.Format("Data Source={0};UTF8Encoding=True;Version=3;", open.FileName); SQLiteConnection sql_con; SQLiteCommand sql_cmd; SQLiteDataAdapter DB; DataSet DS = new DataSet(); sql_con...
    Posted to How To (Forum) by bradak on 03-27-2009
Page 1 of 1 (5 items)
Powered by Community Server (Commercial Edition), by Telligent Systems