I have an sqlite database that has a blob column with blob data. I have tried the following but it is not showing anything. Please advice:
public Cursor getHiddenImages()
{
dbConnection connection=new dbConnection(getApplicationContext());
SQLiteDatabase db=connection.getReadableDatabase();
Cursor cursor=db.query(dbConnection.TABLE_IMAGES,null, null, null, null, null, null);
return cursor;
}
cursor=getHiddenImages();
cursor.moveToFirst();
byte[]mybyteArray=cursor.getBlob(cursor.getColumnIndex(dbConnection.IMAGE_DATA));
Bitmap theImage=BitmapFactory.decodeByteArray(mybyteArray, 0, mybyteArray.length);
imageview.setImageBitmap(theImage);