displaying images from sqlite in android

Question

Hi, I am an android application developer. I am currently developing an application which requires of me to display an image stored in an sqlite database, Could anyone guide me on how to retrieve an image from a sqlite database and display it... Thanks..

Answer 1

I would begin with:

db.rawQuery('SELECT imageBlob FROM Images WHERE imageID=?', new String[] {imageID});

Then save the result to a file (for that bit, I don't know exactly, being new to Android and all).