Srihari
Srihari

Reputation: 2429

How to set string from sqlite to Spinner in Android?

I have Spinner in my app and set String[] programmatic.

speciality = (Spinner) findViewById(R.id.general_specality_s);
specialityadapter = new ArrayAdapter<String>(this,
            android.R.layout.simple_spinner_item, speciality_list);
speciality.setAdapter(specialityadapter);

and get selected string like this speciality.getSelectedItem().toString(); and store in sqlite. Now I want to get that value from sqlite and need to set in Spinner1.

String SpinnerText=c.getString(c.getColumnIndex("speciality"));

How to set this string to speciality / Spinner ? Thanks in advance.

Upvotes: 1

Views: 534

Answers (1)

Chris K.
Chris K.

Reputation: 987

Fetch your data into an array and use an array adapter

String[] spinnerArray = your data goes here;
Spinner spinner = (Spinner)findViewById(R.id.yourspinnerid);
ArrayAdapter<String> spinnerAdapter = new ArrayAdapter<String>(this, android.R.layout.simple_spinner_item, spinnerArray);
spinnerAdapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
spinner.setAdapter(spinnerAdapter);

Upvotes: 1

Related Questions