Update ListView with cursor and SimpleCursorAdapter

Question

My cursor is fetch data from sqlite.

msgsdbadapter = new MSGSDBAdapter(this);
msgsdbadapter.open();
cons_cursor = msgsdbadapter.fetchConversations();
startManagingCursor(cons_cursor);

After that I create a SimpleCursorAdapter and assign it to ListView. The ListView now can display some records well.

String[] from = new String[] { MSGSDBAdapter.KEY_FROM, MSGSDBAdapter.KEY_MSG, MSGSDBAdapter.KEY_DATE};
int[] to = new int[] { R.id.lblFrom, R.id.lblMsgExcerpt, R.id.lblDate };
cons_cursor_adapter = new SimpleCursorAdapter(context, R.layout.conversation_item, cons_cursor, from, to);
lvConversations.setAdapter(cons_cursor_adapter);

Next, I insert new row into table and notify dataset changed, but the ListView is not update

msgsdbadapter.createMsg(msg);
cons_cursor_adapter.notifyDataSetChanged();

And when I should close the db connection?

I think u need to update cursor that u have passed to adapter. — Vivek
– Vivek, Commented Oct 25, 2011 at 8:46
How to update cursor? I can create new cursor and assign it again to adapter. But that way seem bad? — complez
– complez, Commented Oct 25, 2011 at 9:24

CommonsWare · Accepted Answer · 2011-10-25 10:27:26Z

7

You need to either requery() the existing Cursor, or run the query again to get a fresh Cursor and swap the new Cursor into your CursorAdapter.

answered Oct 25, 2011 at 10:27

CommonsWare

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

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

3 Comments

complez Over a year ago

requery is decaperpted. Are there have a new approach for this problem?

CommonsWare Over a year ago

@complez: Run the query again to get a fresh Cursor and swap the new Cursor into your CursorAdapter using changeCursor().

XorOrNor Over a year ago

This updated solution works just fine, but I'm wondering why the adapter.notifyDataSetChanged() is not able to do this itself?

Kix46 · Accepted Answer · 2014-05-02 05:46:57Z

0

The best solution if your using the ListFragment is to put this in inside this sample:

 public SimpleCursorAdapter myNote;
    public class NOteLIST_MAIN extends ListFragment {

    @SuppressWarnings("deprecation")
    @Override
    public void onResume() {
        super.onResume();
        myNote.getCursor().requery();//Don't forget to put these on onResume }

    private void DataLoader(){private void DataFiller(){
          myNote = new SimpleCursorAdapter(getActivity(), R.layout.notes_row_line, notesCursor, from, to,0);
          setListAdapter(myNote);}  
}

answered May 2, 2014 at 5:46

Kix46

211 bronze badge

Collectives™ on Stack Overflow

Update ListView with cursor and SimpleCursorAdapter

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related