How can I create a list Array with the cursor data in Android

android arraylist android-sqlite android-cursor
Dennie picture Dennie · Aug 30, 2009 · Viewed 67.1k times · Source

How can I create a list Array (the list display First Alphabet when scroll) with the cursor data?

Answer

Isaac Waller picture Isaac Waller · Aug 31, 2009

Go through every element in the Cursor, and add them one by one to the ArrayList.

ArrayList<WhateverTypeYouWant> mArrayList = new ArrayList<WhateverTypeYouWant>();
for(mCursor.moveToFirst(); !mCursor.isAfterLast(); mCursor.moveToNext()) {
    // The Cursor is now set to the right position
    mArrayList.add(mCursor.getWhateverTypeYouWant(WHATEVER_COLUMN_INDEX_YOU_WANT));
}

(replace WhateverTypeYouWant with whatever type you want to make a ArrayList of, and WHATEVER_COLUMN_INDEX_YOU_WANT with the column index of the value you want to get from the cursor.)

Related questions

Save ArrayList to SharedPreferences

I have an ArrayList with custom objects. Each custom object contains a variety of strings and numbers. I need the array to stick around even if the user leaves the activity and then wants to come back at a later …

Read More
Add object to ArrayList at specified index

I think it's a fairly simple question, but I can't figure out how to do this properly. I've got an empty arraylist: ArrayList<object> list = new ArrayList<object>(); I've got some objects I want to add …

Read More
Populating a ListView using an ArrayList?

My Android app needs to populate the ListView using the data from an ArrayList. I have trouble doing this. Can someone please help me with the code?

Read More