Show all pictures from database in a GridView

I have stored stored some links from pictures with a text to it in my database, with this:

    int drawableID = context.getResources().getIdentifier("devil", "drawable", getPackageName());
    iv.setImageResource(drawableID);

    String info = String.valueOf(drawableID);

    mDbHelper.open();

    mDbHelper.createSmiley("You received a satanic message", info);

    mDbHelper.close();

Now I have defined a gridview in my layout like this:

        <GridView 
            android:layout_height="175dp" 
            android:layout_width="fill_parent" 
            android:gravity="bottom|right" 
            android:numColumns="5"
             >
        </GridView>

Now I want to import my pictures from my database that they are shown in my GridView and that I can select one of them. But I don't get how 开发者_运维百科this works, how I can realize that? This is my method to import all Database entries:

    public Cursor getAllSmileys() {

        return this.mDb.query(DATABASE_TABLE, new String[] { ROW_ID,
                SOURCE, INFO }, null, null, null, null, null);
    }

So my Question is how I can import all those pictures into my gridview to show them? Also I'd like that the user can select one of them.

Check this Inserting image in Database and get it back.

For Storing image in Database , store it as BLOB and retrieve it back and show it..

In the above example i show how to insert the image in DB and display it it in Image View..