Browse by Tags

Streaming Blob Data

Can anyone tell me if SQLite's incremental blob reading API is supported by System.Data.SQLite? http://www.sqlite.org/capi3ref.html#sqlite3_blob_open I've found it mentioned here back in 2007... http://sqlite.phxsoftware.com/forums/p/780/3438.aspx#3438 And this thread mentions it, but doesn't...

Posted to General (Forum) by antsyawn on 07-20-2010
Retrieving BLOB data from an old sqlite database

Hi! I had been using a C++ wrapper for SQLite to store image data as BLOBs in a table. Before the data is stored, it was encoded using the old sqlite_encode_binary function (which I think is no longer available). So my problem is that after porting the code to C#, the data which used to be stored in...

Posted to How To (Forum) by skyjt on 06-05-2010
Re: Reading/Inserting Blob data from/to table

Try this one fro inserting blob. This works perfectly for me! (just a crude example) Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso...

Posted to How To (Forum) by sajanmani on 09-30-2009
Re: Writing a BLOB to the database in chunks.

This may come late but maybe it will be of interest to other users.. See my reply to another (similar) post request: http://sqlite.phxsoftware.com/forums/p/1110/7371.aspx#7371 . Specifically see the included file for reference code. Liron

Posted to General (Forum) by liron on 09-02-2009
Re: How to write and read an image into a sqlite database in C#

If you are dealing with small images (<1000K) then you can simply use a query such as: INSERT INTO mytable (myid,myblob) VALUES(@myid, @myblob) And define a parameter for the @myblob variable as Binary (Call the command's AddParameter with a Binary field type). If you are dealing with larger BLOBs...

Posted to How To (Forum) by liron on 08-02-2009
How to write and read an image into a sqlite database in C#

Hey All I'm a bit of a newbie to sql. I'm trying to learn how to read and write an image to a sqlite database. Does anyone have any pointers or example code of how to do this? I assume its done by storing the image as an array of blobs, but I have no idea how to do this. Any help would be greatly...

Posted to How To (Forum) by kwi23 on 07-31-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
Re: reading and writing BLOB fields in chunks

Hi The code is attached to my previous post. However - this is not a patch to the .net provider. I didn't have time to do this.. Instead I simply added a separate class for handling BLOB chunking. I think that the .net provider is incomplete without support for BLOB chunking of some sort, but I understand...

Posted to General (Forum) by liron on 05-27-2009

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