How to add data from an SQLite Database into an ArrayList (Android)

Question

I'm relatively new to Android and I was making a To-Do List application. I have a database containing a column of tasks. How can I put these tasks into an ArrayList and display it ?

helper = new TaskDBHelper(MainActivity.this);
        SQLiteDatabase db = helper.getReadableDatabase();
        Cursor cursor = db.query(TaskContract.TABLE, new String[]{TaskContract.Columns._ID,TaskContract.Columns.TASK}, null, null, null, null, null);

        arrayListToDo = new ArrayList<String>();

arrayAdapterToDo = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, arrayListToDo);

        ListView listViewToDo = (ListView) findViewById(R.id.listViewToDo);
        listViewToDo.setAdapter(arrayAdapterToDo);

You could iterate over your Cursor and add the tasks to your ArrayList but I'd suggest you to look into CursorAdapters. — ottel142
– ottel142, Commented Dec 17, 2014 at 10:52

Kaushik · Accepted Answer · 2014-12-17 11:18:26Z

2

Try this code

while (cursor.moveToNext()) {

arrayListToDo.add(cursor.getString(cursor.getColumnIndex("Your column name")));
}

edited Dec 17, 2014 at 11:18

Kaushik

6,1525 gold badges41 silver badges56 bronze badges

answered Dec 17, 2014 at 11:01

Chetan Gaikwad

1,2681 gold badge14 silver badges26 bronze badges

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

Comments

A-Droid Tech · Accepted Answer · 2014-12-17 10:52:26Z

0

You can get the data in Array list :-

ArrayList<String> arrayListToDo= new ArrayList<String>();  
//your query will returns cursor
if (cursor.moveToFirst()) {
  do {
    arrayListToDo.add(get you string from cursor);
  } while (cursor.moveToNext());
}

now add this aray list to your Adapter.

answered Dec 17, 2014 at 10:52

A-Droid Tech

2,33126 silver badges33 bronze badges

Comments

Naveen Tamrakar · Accepted Answer · 2014-12-17 10:53:39Z

get list data from database this is only overview

     ArrayList<String> data = databaseObject.GetList();
ListView listViewToDo = (ListView) findViewById(R.id.listViewToDo);
arrayAdapterToDo = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, data);
listViewToDo.setAdapter(arrayAdapterToDo);


      ArrayList<String> GetList()
    {
        ArrayList<String> arrayListtemp= new ArrayList<String>();
        SQLiteDatabase db = helper.getReadableDatabase();
        Cursor cursor = db.query(TaskContract.TABLE, new String[]{TaskContract.Columns._ID,TaskContract.Columns.TASK}, null, null, null, null, null);
        if (cursor.moveToFirst()) {
            do {
                arrayListtemp.add("");// added your table value from database
            } while (cursor.moveToNext());
        }
        return arrayListtemp;
    }

Collectives™ on Stack Overflow

How to add data from an SQLite Database into an ArrayList (Android)

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related