Spinner Eintrag hinzufügen

1private void fillCatagoriesSpinner() {
2 ArrayAdapter adapter = new ArrayAdapter<String>(this, android.R.layout.simple_spinner_item);
3 adapter.setDropDownViewResource(android.R.layout.simple_spinner_item);
4 mCatagoriesSpinner.setAdapter(adapter);
5
6 Cursor catagoriesCursor = Category.findAll(mDb);
7 int accountnameIndex = catagoriesCursor.getColumnIndexOrThrow(Category.NAME);
8 if(catagoriesCursor.moveToFirst()){
9 do{
10 adapter.add(catagoriesCursor.getString(accountnameIndex));
11 } while(catagoriesCursor.moveToNext());
12 adapter.add("Neue Kategorie");
13 }

1public static Cursor findAll(SQLiteDatabase db) {
2 Cursor category_cursor = db.query(Category.TABLE_NAME,
3 new String[]{Category.ID, Category.NAME}, null, null, null, null, null);
4 return category_cursor;
5}

1private void fillFields() {
2 if (mDbItemId != null) {
3 fillCatagoriesSpinner();
4
5 Cursor itemCursor = Item.find(mDb, mDbItemId);
6 startManagingCursor(itemCursor);
7
8 mItemNameField.setText(itemCursor.getString(itemCursor.getColumnIndexOrThrow(Item.NAME)));
9 mItemAmountField.setText(itemCursor.getString(itemCursor.getColumnIndexOrThrow(Item.AMOUNT)));
10
11 long catagory_id = itemCursor.getInt(itemCursor.getColumnIndexOrThrow(Item.CATAGORY_ID));
12 for (int i = 0; i < mCatagoriesSpinner.getCount(); i++) {
13 Cursor value = (Cursor) mCatagoriesSpinner.getItemAtPosition(i);
14 if (value.getLong(value.getColumnIndex("_id")) == catagory_id) {
15 mCatagoriesSpinner.setSelection(i);
16 }
17 }
18 }
19 }
20
21 private void fillCatagoriesSpinner() {
22 Cursor catagoriesCursor = Category.findAll(mDb);
23
24 startManagingCursor(catagoriesCursor);
25
26 mCatagoriesSpinner.setAdapter(new SimpleCursorAdapter(this,
27 android.R.layout.simple_spinner_item,
28 catagoriesCursor,
29 new String[]{Category.NAME},
30 new int[]{android.R.id.text1}));
31 }

109:47:12.554 327 ERROR AndroidRuntime java.lang.RuntimeException: Unable to start activity ComponentInfo{de.android.shoppinglist/de.android.shoppinglist.EditItem}: java.lang.IllegalArgumentException: column '_id' does not exist