Sign in
|
Join
|
Help
in
Current Tags
(Entire Site)
System.Data.SQLite
An open source ADO.NET provider for the SQLite database engine
Home
Forums
All Tags
»
Blob
(RSS)
Browse by Tags
Beginner
C#
C#.net
C++
chunking
chunks
DataType
image
newbie
picture
read
Reading Blob
sqlite
sqlite_decode_binary
sqlite_encode_binary
stream
vs2008
VS2010
write
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 >