Extract data from ListView

Question

I populated my ListView with data from my database table.

How can I get data from selected item?

This is how I populate ListView:

    SimpleCursorAdapter SimpleCursorAdapter;
ListView listCategories = (ListView) findViewById(R.id.categoryList);
categoryRepo categoryRepo = new categoryRepo(this);
TextView textview= (TextView) findViewById(R.id.textView);

private void displayCategories()
{
    Cursor cursor = categoryRepo.getCategories();

    if (cursor == null)
    {
        textview.setText("Error");
        return;
    }
    if (cursor.getCount() == 0)
    {
        textview.setText("No categories.");
        return;
    }

    String[] from = new String[] {category.KEY_CATEGORY_NAME};
    int[] to = new int[] {android.R.id.text1};

    SimpleCursorAdapter = new SimpleCursorAdapter(this,android.R.layout.simple_list_item_1,cursor,from,to,0);
    listCategories.setAdapter(SimpleCursorAdapter);

}

I know that I can do this by using listCategories.setOnItemClickListener , but I do not know how. Thank you for help.

I want to get CATEGORY_NAME value.

rhari · Answer 1 · 2016-11-26T17:42:54.290

1

Try this :

listCategories.setOnItemClickListener(new AdapterView.OnItemClickListener() {
        @Override
        public void onItemClick(AdapterView<?> adapterView, View view, int position, long l) {
            Cursor cursor = (Cursor) adapterView.getItemAtPosition(position);
            if (cursor.moveToFirst()){
                String selectedValue = cursor.getString(cursor.getColumnIndex(category.KEY_CATEGORY_NAME));
                // do what ever you want here
            }
            cursor.close();
        }
    });

edited Nov 26 '16 at 17:42

answered Nov 26 '16 at 17:09

rhari

1,367
1
11
19

I got this error : java.lang.ClassCastException: android.database.sqlite.SQLiteCursor cannot be cast to java.lang.String – ktos1234 Nov 26 '16 at 17:32
Edited, have a look – rhari Nov 26 '16 at 17:43

score 1 · Accepted Answer · edited May 23 '17 at 12:24

1

listCategories.setOnItemClickListener(new OnItemClickListener(){
    @Override
    public void onItemClick(AdapterView<?> arg0, View arg1, int position,
            long arg3) {
        // TODO Auto-generated method stub

         Cursor cursor = (Cursor) SimpleCursorAdapter.getItem(position);
    }
});

How to get string from selected item of SimpleCursorAdapter?

edited May 23 '17 at 12:24

Community

1
1

answered Nov 26 '16 at 17:12

Jayakrishnan

4,457
29
29

Ok, but how can I get this data in string? Never mind, I figured it out. Thank you! It works better than I expected. (cursor.getString(cursor.getColumnIndex(category.KEY_ID))) – ktos1234 Nov 26 '16 at 17:35
It works good, but can I ask you to explain me what do mean parameters in OnItemClick method?, I mean arg0, arg1 and arg3?? – ktos1234 Nov 26 '16 at 17:42
1

https://developer.android.com/reference/android/widget/AdapterView.OnItemClickListener.html – Jayakrishnan Nov 26 '16 at 17:43

Extract data from ListView

2 Answers2