lundi 13 avril 2015

SQLite Select all rows and add to ListView Android

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