I want to add each row retrieved from database to the list view here's what I have done so far.
code from activity class
private void getList() {
list.add(dbms.selectAllFromRatings());
arrayAdapter = new ArrayAdapter<String>(StationListView.this,
android.R.layout.simple_list_item_1, list);
listView.setAdapter(arrayAdapter);
}
// code from databaseHelper class
public String selectAllFromRatings() {
String selectAllQuery = " SELECT * FROM " + RATING_TABLE_NAME ;
SQLiteDatabase sql = this.getReadableDatabase();
Cursor c = sql.rawQuery(selectAllQuery, null);
c.moveToFirst();
return c.getString(c.getColumnIndex("stationName1"));
}
Aucun commentaire:
Enregistrer un commentaire