'Using SimpleCursorAdapter with Spinner?

I have a db with table "mytable" having 2 colums "id","sampletext" I want to query distinct values of sampletext and feed to a Spinner using SimpleCursorAdapter.

here is what is tried

String[] cols=new String[]{"sampletext"};
int[] lbls=new lbls[]{android.R.id.text1};
mycursor=sdb.query(true,"mytable", cols,null,null,null,null,null,null);
sca=new SimpleCursorAdapter(this, android.R.layout.simple_spinner_item, mycursor, cols,lbls,0);
sca.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
spn.setAdapter(sca);

When i run this i get error at line 4 : id does not exist. when i changed first line to "id" the spinner got populated with id values. But i need "sampletext", what am i doing wrong? Appreciate any suggestions

Solution 1:^[1]

Here's an example with raw query. Please note the first ID column returned by the query should be labeled as _id .

MyDatabase.java:

public class MyDatabase extends SQLiteAssetHelper {
     ...
    public Cursor getListNamesForDropDown() {
        SQLiteDatabase db = getReadableDatabase();
        String sql = "select ID _id, Name from MyTable order by Name ";
        Cursor c = db.rawQuery(sql, null);
        c.moveToFirst();
        return c;
    }

MyActivity.java:

        @Override
        public void onCreate(Bundle savedInstanceState) {
....    
           Cursor cursorTest =  db.getListNamesForDropDown();
           android.widget.SimpleCursorAdapter  adapter = new android.widget.SimpleCursorAdapter(this, 
                   android.R.layout.simple_spinner_item,
                    cursorTest, 
                    new String[] {"Name"}, 
                    new int[] {android.R.id.text1}, 0);       
           adapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
           spinnerTest.setAdapter(adapter);

Solution 2:^[2]

android.widget.SimpleCursorAdapter adapter = new android.widget.SimpleCursorAdapter(this,
            android.R.layout.simple_spinner_item,
            cursor,
            new String[] { DBOpenHelper.ACCOUNT_BANK },
            new int[] { android.R.id.text1 }, 0);

adapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	live-love
Solution 2	Kurt Van den Branden

'Using SimpleCursorAdapter with Spinner?

Solution 1:[1]

Solution 2:[2]

Sources

Related Questions

Solution 1:^[1]

Solution 2:^[2]