how to refresh listview with sqlite DB

Question

im trying to refresh my listview after i deleted a row from SQLite DB. This is part of it:

cursor = mysqlAdapter.fetchAll(); // a method from sqlite adater class 
ArrayList<MyInfo> vidRows = new ArrayList<MyInfo>(); 
if (cursor.moveToFirst()) { 
do { ...... } 
while (cursor.moveToNext()); } 
mList.setAdapter(new SomeAdapter(this, vidRows)); 
mList.setOnItemClickListener(this); 
registerForContextMenu(mList); }

Then in my getView i do:

public View getView(int position, View convertView, ViewGroup parent) { 
View vidRow = inflater.inflate(R.layout.queue_row, null); 
ImageView vidThumb = (ImageView) vidRow .findViewById(R.id.Thumb); 
Bitmap bmThumbnail; bmThumbnail = ThumbnailUtils.createVideoThumbnail(
                     getFullpath(vidItems.get(position).my_id), Thumbnails.MINI_KIND);      
vidThumb.setImageBitmap(bmThumbnail); 
TextView vidText = (TextView) vidRow .findViewById(R.id.vid_cap);
videoText.setText(vidItems.get(position).my_cap); return vidRow; }

citizen conn · Accepted Answer · 2011-06-28 22:23:08Z

1

Are you using a cursor? If so you can just call:

cursor.requery();

answered Jun 28, 2011 at 22:23

citizen conn

15.4k3 gold badges61 silver badges80 bronze badges

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

7 Comments

dmon Over a year ago

That comes with a few caveats, but it works.

citizen conn Over a year ago

fair nuff. I have used it in the past for a delete only, but for sorting or anything else I request a new cursor.

Codes12 Over a year ago

i am using cursor to query the DB. I have tried cursor.requery() but it doesnt work.

citizen conn Over a year ago

I know you're using a cursor to query the DB but I don't know how you're populating your listview, SimpleCursorAdapter? If so then after you delete your row, you call requery it should work.

citizen conn Over a year ago

Can you update your question with this code (formatted) and I will update my answer.

|

Suchi · Accepted Answer · 2011-06-28 22:29:03Z

0

Are you using a list to populate your ListView? I would prefer doing it manually like this -

myList.remove(delPos);
getListView().invalidateViews();

answered Jun 28, 2011 at 22:29

Suchi

10k23 gold badges70 silver badges113 bronze badges

2 Comments

Codes12 Over a year ago

no i am not using a list...im using cursor with DB and some images from a folder. Anyone.....?

Suchi Over a year ago

I saw your code above in the comments. You are using vidRows to populate your list. This code should work for you.

levyian · Accepted Answer · 2014-07-15 12:25:15Z

0

I know this is kinda old but I'll reply in case anyone else have the same issue and it can help.

You could use a cursor adapter and pass the cursor to it using swapCursor (also works when using onCursorLoader) then whenever you delete a row you could do one of the follow:

delete a row from your db outside of the adapter and then call adapter.notifyDataSetChanged()

or

embed the db inside your adapter and create a delete method so when you call adapter.delete() is updates both the list (if you still use it) and the db.

answered Jul 15, 2014 at 12:25

levyian

112 bronze badges

Collectives™ on Stack Overflow

how to refresh listview with sqlite DB

3 Answers 3

7 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related