lundi 16 février 2015

how would i display multiple data from an sqlite database in android

i cant seem to display multiple data from my database. only one data from my database gets printed.


DatabaseHelper:



public Cursor returnData2(String text, String look){
String data;
String where = "_column LIKE '"+look+"%'";


Cursor c = myDataBase.query("translate_metadata", null, where, null, null, null, null);

c.moveToFirst();
while(!c.isAfterLast()){

c.moveToNext();
}
return c;

}


activity:



String inputtext = ((EditText) findViewById(R.id.inputKey)).getText().toString();
String lowerinput = inputtext.toLowerCase();
data = myDbHelper.returnData2("databasename",lowerinput);
if(data.moveToFirst()){
rdata = data.getString(1);
((TextView) findViewById(R.id.keyList)).setText(""+rdata.toString()+"\n");

}

myDbHelper.close();
}


sorry if its confusing. but i need the help. any suggestion will do. thanks


Aucun commentaire:

Enregistrer un commentaire