Update listview after update database sqlite

Question

How to update items in listview after update the row on database sqlite. I have put notifyDataSetChanged() but not success, there is not error, but not refresh data in row. The data will change if I click menu back and open list again. So I want update the data in row after I update data. Below structur my code, Thanks.

CustomBaseAdapter adapter;
ListView cListView;

in onCreate:

cListView = (ListView) findViewById(R.id.list_category);
List<ItemsArtikel> rowItems = (List<ItemsArtikel>) db.getAllCategory(katname);
adapter = new CustomBaseAdapter(this, rowItems);
cListView.setAdapter(adapter);

Query listcategory:

public List<ItemsArtikel> getAllCategory(String cat) {
    SQLiteDatabase db = this.getWritableDatabase();
    List<ItemsArtikel> cList = new ArrayList<ItemsArtikel>();
    String selectQuery = "SELECT  * FROM " + TABLE_CAT + " WHERE "
            + COLOM_KAT + "=\"" + cat + "\"";
    Cursor c = db.rawQuery(selectQuery, null);
    c.moveToFirst();
    if (c.getCount() > 0) {
        do {
            ItemsArtikel kat = new ItemsArtikel();
            kat.setID(c.getLong(c.getColumnIndex(COLOM_ID)));
            kat.setName(c.getString(c.getColumnIndex(COLOM_NAME)));
            kat.setLink(c.getString(c.getColumnIndex(COLOM_LINK)));
            kat.setImage(c.getString(c.getColumnIndex(COLOM_IMAGE)));
            kategoriList.add(kat);
        } while (c.moveToNext());
    }
    return cList;
}

After i use for listview is presented for to download images and update each row the database using AsyncTask when download image. Image success downloaded and row also success updated, Just not refresh in listview.

This is code onPostExecute when download image:

@Override
protected void onPostExecute(HashMap<String, Object> result) {
    String id = (String) result.get("id");
    String path = (String) result.get("image");

    // update row in database
    db.updateRowCategory(id, path);

    cListView.setAdapter(adapter);
    adapter.notifyDataSetChanged();
}

Animesh Sinha · Accepted Answer · 2013-02-14 03:43:42Z

2

On calling notifyDataSetChanged() it will just notify the register view to update the content to reflect the changes.

In your case you are updating data in Database not in Adapter Data model. To reflect the changes in ListView you need to updated the Adapter's datamodel and then call notifyDataSetChanged();

OR

If your are rendering data directly from Database use CursorAdapter and implement onContentChanged () for updating ListView

answered Feb 14, 2013 at 3:43

Animesh Sinha

1,0459 silver badges16 bronze badges

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

1 Comment

Dave Jackson Over a year ago

Hello Animesh, thanks for reply. I have update my post so how about to use onContentChanged(), if I can use a query like the one above.

Kels · Accepted Answer · 2013-02-14 06:42:43Z

0

Use following line before add adapter.

@Override
protected void onPostExecute(HashMap<String, Object> result) {
    String id = (String) result.get("id");
    String path = (String) result.get("image");

    // update row in database
    db.updateRowCategory(id, path);
    cListView.Invalidate();
    cListView.setAdapter(adapter);
    cListView.Invalidate();
    adapter.notifyDataSetChanged();
}

edited Feb 14, 2013 at 6:42

answered Feb 14, 2013 at 5:46

Kels

6741 gold badge5 silver badges21 bronze badges

1 Comment

Dave Jackson Over a year ago

Before where? can you please copy my code to your answer, thanks

Collectives™ on Stack Overflow

Update listview after update database sqlite

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related