how to display(retrive) image from sqlite database
<p>Json FUnction able do parse data  and insert value in sq-lite database</p>

<pre><code>for (int i = 0; i &lt; jArray6.length(); i++) {
                    catagoryid = 5;
                    json_data = jArray6.getJSONObject(i);
                    // news_id = Integer.parseInt((json_data.getString("news_id")));
                    news_id = Double.parseDouble(json_data.getString("news_id"));
                    news_title = json_data.getString("news_title");
                    imagepath = json_data.getString("imagepath").trim().getBytes();
                    news_short_description = json_data
                            .getString("news_short_description");
                    news_detail = json_data.getString("news_detail_description");
                    news_date = json_data.getString("news_date");
                    website_link = json_data.getString("website_link").trim();
                    dh = new DBhelper(TaxMann.this);
                    record_id = dh.AddMsgt1(news_id, catagoryid, news_title,
                            imagepath, news_short_description, news_date,
                            news_detail, website_link);
                }
</code></pre>

<p>this my database class function </p>

<pre><code>@Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        db.execSQL("CREATE TABLE " + topstories
                + "(_id INTEGER PRIMARY KEY AUTOINCREMENT," + news_id
                + " double, " + catagory_Id + " integer," + news_title
                + " text," + imagepath + " BLOB, " + short_description
                + " text, " + news_date + " text, " + detailed_news + " text, "
                + website_link + " text)");
        db.execSQL("CREATE TABLE " + savednews
                + "(_id INTEGER PRIMARY KEY AUTOINCREMENT," + news_id
                + " double," + news_title + " text," + imagepath + " BLOB,  "
                + detailed_news + " text)");
        db.execSQL("CREATE TABLE " + date
                + "(_id INTEGER PRIMARY KEY AUTOINCREMENT," + modified_date
                + " integer)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub
        db.execSQL("drop table if exists " + topstories);
        db.execSQL("drop table if exists " + savednews);
        db.execSQL("drop table if exists " + date);
        onCreate(db);
    }

    // records for newstable

public int AddMsgt1(double newsid, Integer cat_id, String title,
        byte[] image, String desc, String date, String detail,
        String website) {
    db = this.getWritableDatabase();
    ContentValues cv = new ContentValues();
    cv.put(news_id, newsid);
    cv.put(catagory_Id, cat_id);
    cv.put(news_title, title);
    cv.put(imagepath, image);
    cv.put(short_description, desc);
    cv.put(news_date, String.valueOf(date));
    cv.put(detailed_news, detail);
    cv.put(website_link, website);

    long record_id = db.insert(topstories, news_title, cv);
    db.close();
    return (int) record_id;
}

public Cursor fetchtitle(int catagoryid) {
            SQLiteDatabase db1 = this.getReadableDatabase();
            cursor = db1.query(topstories,
                    new String[] { "_id", "news_title", "imagepath",
                            "short_description", "news_date", "detailed_news", },
                    "catagory_id=" + catagoryid, null, null, null, null, null);
            return cursor;
        }
</code></pre>

<p>from this i am able to display title and description an all but i m not able to display image </p>

<pre><code>public void simple_ad(Cursor cursor,int category_id)
    {
        dh = new DBhelper(this);
        ListView list = (ListView)findViewById(R.id.expertscommentsListView);
        String[] colummnames = { "news_title","imagepath","descripton"}; 
        cursor = dh.fetchtitle(category_id);
        int []id=  { R.id.titleTextView,R.id.descriptionTextView,R.id.imagview2};
        SimpleCursorAdapter adapter = new SimpleCursorAdapter(this,  R.layout.new_list, cursor , colummnames,id);
        list.setAdapter(adapter);
        adapter.notifyDataSetChanged();
        list.setOnItemClickListener(this);
    }
</code></pre>

<p>i have shown database file apply select * from table name i have shown data IMage path column with its value But am not able to display please help where i m doing wrong i have taken r.imageview</p>
