How to fill a listview from database using an SimpleCursorAdapter

Question

I get some data from the database and try to fill them in a listview. i have checked through cursor.count() there is data exist but the listview show anything :/

I use a simpleCursorAdapter:

    rubDb.open();   
    cur = rubDb.getRubParent();     
    startManagingCursor(cur);
    Log.d("cursor length",Integer.toString(cur.getCount()));
    String[] from = new String[] { RubriqueDbAdapter.RUB_NOM, RubriqueDbAdapter.RUB_VISUEL };       
    int[] to = new int[] {R.id.title, R.id.icon};
    listAdapter = new SimpleCursorAdapter(this,  R.layout.itemgauche, cur, from, to);
    listeGauche.setAdapter(listAdapter);


public Cursor getRubParent() {              
    Cursor cursorResults = mDb.rawQuery("SELECT * FROM " + TABLE_RUBRIQUE + " WHERE rub_id_parent = 0 ORDER BY rub_ordre ASC", null);       
    return cursorResults;
}

how can I get a picture from the sdcard and put it on the ImageView in the listview ?

Thanks for your help !

ok, I make a customlistadapter which extends ArrayAdapter, here the getView() method, but now how to setText with the right title extract from the database? tx — Remy
– Remy, Commented Mar 13, 2012 at 16:37

CommonsWare · Accepted Answer · 2012-03-13 16:37:22Z

1

First, you should be using a CursorAdapter, perhaps a SimpleCursorAdapter, instead of manually copying all of the data into objects in an array, just to use ArrayAdapter.

Second, if your list will be anything other than a simple piece of text, you must teach the adapter how to do whatever else you want. With SimpleCursorAdapter, you could associate a ViewBinder with it, or subclass SimpleCursorAdapter and override setViewImage(), or subclass SimpleCursorAdapter and override bindView().

answered Mar 13, 2012 at 16:37

CommonsWare

1.0m195 gold badges2.4k silver badges2.7k bronze badges

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

2 Comments

Remy Over a year ago

Ok I made some changes, can you check it please

CommonsWare Over a year ago

@Remy: To use CursorAdapter or subclasses, you need an _id column in the Cursor. Typically, that would be the primary key of the table you are querying.

Collectives™ on Stack Overflow

How to fill a listview from database using an SimpleCursorAdapter

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related