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
Read blob from database in c++

Hey everybody, I'm working on C++ Flash Card application for which I need to store pictures of any format into a database. I have the insert portion functioning, but the problem is that I cannot figure out how to get the data from the database back into a PictureBox->Image. I've tried using...

Posted to How To (Forum) by DamareYoh on 10-31-2010
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

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