Android array list from database

Question

I wanna create an array of cities that are stored in the database

Cities Table

CREATE TABLE cities (_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT);

Querying for City List

// City List
public Cursor cityList() throws SQLException {
    return db.query(TABLE_CITIES, new String[] {ID, KEY_NAME}, null, null, null, null, null, null);
}

Trying to Get the content into the Array

    Cursor cities = db.cityList();
    startManagingCursor(cities);

    String[] city_list = new String[] { DBAdapter.KEY_NAME };
    Spinner cityList = (Spinner)this.findViewById(R.id.citySpiner);
    ArrayAdapter<String> adapter = new ArrayAdapter<String>(this,android.R.layout.simple_spinner_item, city_list);
    adapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
    cityList.setAdapter(adapter);

Am not able to populate the Spinner.. with the database content.

hi harsha did you get any error while executing this... Also check whether the cities cursor has some content in it.. — Dinash
– Dinash, Commented Apr 28, 2011 at 11:39

Adil Soomro · Accepted Answer · 2011-04-28 12:05:47Z

1

Try SimpleCursorAdapter

String[] from = new String[] {  DBAdapter.KEY_NAME  };
int[] to = new int[] {android.R.id.text1};
SimpleCursorAdapter cursorAdapter = new SimpleCursorAdapter(context, android.R.layout.simple_spinner_dropdown_item , cursor, from, to);
cityList.setAdapter(cursorAdapter);

Edit:

from means the column(s) from the Cursor which will be used to display as text array in Spinner. to means the id(s) of the view which will hold the value of that column. It is very interesting that the view at index N will hold the text from column at N.

edited Apr 28, 2011 at 12:05

answered Apr 28, 2011 at 11:40

Adil Soomro

37.7k9 gold badges105 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Harsha M V Over a year ago

can u explain to me what is String from and int[] to ?

Harsha M V Over a year ago

Thanks for the explanation buddy :) its a little confusing but got the idea :)

Collectives™ on Stack Overflow

Android array list from database

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related