private void putInList() { Cursor c = mDbHelper.getAllRows(); // Cursor life time startManagingCursor(c); // Cursor map to view fields String[] fieldNames = new String[] { DBAdapterUsers.KEY_ROWID, DBAdapterUsers.KEY_USERFNAME, DBAdapterUsers.KEY_USERSNAME, DBAdapterUsers.KEY_USERNUM, DBAdapterUsers.KEY_USEREMAIL }; int[] getIds = new int[] { R.id.textViewUserID, R.id.textViewFname, R.id.textViewSname, R.id.textViewNum, R.id.textviewEmail }; SimpleCursorAdapter cAdapter = new SimpleCursorAdapter(this, R.layout.user_layout, c, fieldNames, getIds); ListView UserList = (ListView) findViewById(R.id.listViewUsers); UserList.setAdapter(cAdapter); }
@Override protected void onPrepareDialog(int id, Dialog dialog) { switch (id) { case 0: UserList.clear(); Cursor c = mDbHelper.getAllRows(); startManagingCursor(c); c.moveToFirst(); for (int i = 0; i < c.getCount(); i++) { UserList.add(c.getString(c.getColumnIndex("userfname"))); c.moveToNext(); } UserItems = UserList.toArray(new CharSequence[UserList.size()]); AlertDialog ad = (AlertDialog) dialog; ad.getListView() .setAdapter( new ArrayAdapter<String>(this, android.R.layout.select_dialog_item, UserList)); } }