CODEWITHSUNDEEP
androidsqlitespinner
Shrei
Shrei

Reputation: 55

storing selected values of spinner in sqlite

I need to store the value selected from the spinner into my already existing table in sqlite database.I cannot get a clear idea from the internet because it only shows how to enter the spinner values in db and not the selected value.This is the code for implementing spinner(static)

 Spinner staticSpinner = (Spinner) findViewById(R.id.static_spinner);

    // Create an ArrayAdapter using the string array and a default spinner
    ArrayAdapter<CharSequence> staticAdapter = ArrayAdapter
            .createFromResource(this, R.array.man_array,
                    android.R.layout.simple_spinner_item);

    // Specify the layout to use when the list of choices appears
    staticAdapter
            .setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);

    // Apply the adapter to the spinner
    staticSpinner.setAdapter(staticAdapter);

    Spinner dynamicSpinner = (Spinner) findViewById(R.id.dynamic_spinner);

    String[] items = new String[] {"rate_of_flow", "30", "40", "50" };

    ArrayAdapter<String> adapter = new ArrayAdapter<String>(this,
            android.R.layout.simple_spinner_item, items);

My application can use both dynamic and static spinner.I don't have any preference.Can you help me?

Upvotes: 1

Views: 5106

Answers (2)

Chaudhary Amar
Chaudhary Amar

Reputation: 856

Try This: 

spinner.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {
        @Override
        public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
            String string = (String) spinner.getItemAtPosition(spinner.getSelectedItemPosition());
            Toast.makeText(YourActivity.this, "Selected Item "+string, Toast.LENGTH_SHORT).show();

        }

        @Override
        public void onNothingSelected(AdapterView<?> parent) {

        }
    });
}

Upvotes: 1

Shree Krishna
Shree Krishna

Reputation: 8562

Why don't you simply get the selected item and insert the selected value in database like here

    spinner.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {
        @Override
        public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
            String selected = parent.getItemAtPosition(position).toString();
            //Code to insert selected string in database
        }

        @Override
        public void onNothingSelected(AdapterView<?> parent) {

        }
    });

Upvotes: 1

Related Questions