android - SQLite Query data retrieve from cursor -
i have 2 edit boxes in ui. want retrieve data table , want insert retrieved data edit text boxes how can insert data edit text boxes cursor?
check no. of column , name cursor.getcolumncount()
, cursor.getcolumnname(0).
respectively.if column count 2
cursor have 2 column
cursor.movetofirst(); string columnname1 = cursor.getcolumnname(0); string columnname2 = cursor.getcolumnname(1); string str1 = cursor.getstring(cursor.getcolumnindex(columnname1))); string str2 = cursor.getstring(cursor.getcolumnindex(columnname2))); editext1.setext(str1); editext2.setext(str2);
after completion of getting data database close cursor using cursor.close();
Comments
Post a Comment