public void dataReadToList() { tasksDB.open(); Cursor c = tasksDB.getAllTasks(); if (c.moveToFirst()) { do { // get ids of each tasks.add( new TaskData( c.getInt(c.getColumnIndex("_id")), c.getString(c.getColumnIndex("taskTitle")), c.getString(c.getColumnIndex("taskDateDue")), c.getString(c.getColumnIndex("taskDateDueTime")), context)); } while (c.moveToNext()); } Collections.sort(tasks, new TaskData()); // TODO: move aside already completed tasks or duedates that have // already passed (display in red font next to task? tasksDB.close(); }