Browse by Tags

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
Re: Incremental Blob I/O

I've tested SQLite with BLOB fields of 700 MB. In my experience - the sqlite DLL code has a major flaw that causes it to consume hundreds of megabytes of RAM when you try to use the zeroblob API to prepare the BLOB for writing. I know this to be true since I'm working on a diff-merge application...

Posted to Feature Requests (Forum) by liron on 05-26-2009
Re: How to Insert a BLOB into database in chunks (Chunking BLOB updates)?

Hi I've had the same problem. It seems that the current version of the .net provider does not support this functionality even though the sqlite library supports it. I've wrote a simple example that you can copy and paste to your application. I hope it will help you. Note that you can't use...

Posted to How To (Forum) by liron on 05-24-2009

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