private void fillData() { // Get all of the rows from the database and create the item list mDbHelper.open(); Cursor airNotesCursor; airNotesCursor = mDbHelper.fetchAllNotes(); startManagingCursor(airNotesCursor); String[] from = new String[] { AirNotesDbAdapter.KEY_CODE, AirNotesDbAdapter.KEY_COUNTRY_CODE, AirNotesDbAdapter.KEY_DAY, AirNotesDbAdapter.KEY_MONTH, AirNotesDbAdapter.KEY_YEAR }; // and an array of the fields we want to bind those fields to (in this case just text1) int[] to = new int[] {R.id.textCode, R.id.flagCountry, R.id.textDay, R.id.textMonth, R.id.textYear}; // Now create a simple cursor adapter and set it to display AirNoteListAdapter airNotes = new AirNoteListAdapter(this, R.layout.airnotes_row, airNotesCursor, from, to); setListAdapter(airNotes); mDbHelper.close(); } // fillData
@Override public boolean onContextItemSelected(MenuItem item) { switch (item.getItemId()) { case DELETE_ID: AdapterContextMenuInfo info = (AdapterContextMenuInfo) item.getMenuInfo(); mDbHelper.open(); mDbHelper.deleteAirNote(info.id); mDbHelper.close(); fillData(); return true; } // switch return super.onContextItemSelected(item); } // onContextItemSelected