Apps Dynamic Spinner Using SQLite Database

[mills2533]

I've been able to successfully link two spinners to a database using a SimpleCursorAdapter. But, I need to make the second spinner selection dependant on the first spinner selection.

Here is how I linked the data:

        cYear = (Cursor) DataBaseHelper.getEPADataYear();
        this.startManagingCursor(cYear);

        SimpleCursorAdapter scaYear = new SimpleCursorAdapter(this, R.layout.spinner_layout,cYear,new String[] {DataBaseHelper.EPA_COLUMN_ONE},new int[]{R.id.text1});
        scaYear.setDropDownViewResource(R.layout.spinner_dropdown);
        mYearSpinner = (Spinner) findViewById(R.id.yearSpinner);
        mYearSpinner.setAdapter(scaYear);

        cMake = (Cursor) DataBaseHelper.getEPADataMake();
        this.startManagingCursor(cMake);

        SimpleCursorAdapter scaMake = new SimpleCursorAdapter(this, R.layout.spinner_layout,cMake,new String[] {DataBaseHelper.EPA_COLUMN_TWO},new int[]{R.id.text1});
        scaMake.setDropDownViewResource(R.layout.spinner_dropdown);
        mMakeSpinner = (Spinner) findViewById(R.id.makeSpinner);
        mMakeSpinner.setAdapter(scaMake);

I've found code for setOnItemSelectedListener and tried to add my code for linking the data to the spinner but the startManagingCursor method and SimpleCursorAdapter constructors give me an error as undefined. Should I use an ArrayAdapter to populate my spinners? Or is there a way to correct the code below?

        mYearSpinner.setOnItemSelectedListener(new OnItemSelectedListener() {
            @Override
            public void onItemSelected(AdapterView<?> parentView, View selectedItemView, int position, long id) {
                // your code here
                cMake = (Cursor) DataBaseHelper.getEPADataMake();
                this.startManagingCursor(cMake);

                SimpleCursorAdapter scaMake = new SimpleCursorAdapter(this, R.layout.spinner_layout,cMake,new String[] {DataBaseHelper.EPA_COLUMN_TWO},new int[]{R.id.text1});
                scaMake.setDropDownViewResource(R.layout.spinner_dropdown);
                mMakeSpinner = (Spinner) findViewById(R.id.makeSpinner);
                mMakeSpinner.setAdapter(scaMake);
            }

            @Override
            public void onNothingSelected(AdapterView<?> parentView) {
                // your code here
            }

        });