How to save a picture to sqlite,and how to display it?

imagex · Joined: 18 Apr 2007 Posts: 1

I can display the picture like this:

Chris Miller · Joined: 27 Mar 2004 Posts: 514 Location: The Internet

Saving binary to sqlite requires you to pass the data through a conversion function that escapes values that are illegal in the SQL queries. There is a function provided by sqlite to do this. You will have to do the opposite conversion when retrieving from the database.

Picture also lets you load the data from a Stream, so you can wrap the image data from sqlite in a MemoryStream and load it this way.