android - Retrieve blob from sqlite -


i retrieve blob database base on row position

i'm retrieving data sqlite database using cursor

 public cursor gettestdata(int index,string house)   {       try       {           string sql ="select * heroes position ="+ index +" , house='"+house+"'";                       cursor mcur = mdb.rawquery(sql, null);           if (mcur!=null)           {              mcur.movetofirst();           }           return mcur;       }       catch (sqlexception msqlexception)        {           log.e(tag, "gettestdata >>"+ msqlexception.tostring());           throw msqlexception;       }   } 

this returns me columns , can strings

cursor testdata = mdbhelper.gettestdata(pos,house);  string sname = utility.getcolumnvalue(testdata, "name"); string sadvance = utility.getcolumnvalue(testdata, "class"); 

this return column "name" , "class" value, how retrieve blob , show it.

byte[] img = utility.getimage(testdata, "image1"); 

this how im trying

public static byte[] getimage(cursor cur,string columnname){     return cur.getblob(cur.getcolumnindex(columnname)); } 

but getting null in img :(


Comments

Popular posts from this blog

design - Custom Styling Qt Quick Controls -

Unable to remove the www from url on https using .htaccess -