Hi,
Use OnTouchListener for spinner instead of using
setOnItemSelectedListener. Spineer excutes its setOnItemSelectedListener in
onCreate so you getting this problem.
On Fri, Dec 30, 2011 at 5:34 PM, vinitvikash vinitvik...@gmail.com wrote:
I have a problem on Android Spinner.In my application I created two
Spinner on main layout. 'State' Spinner and 'District' Spinner. All
the data on Spinner are stored in SQLite database. I want do display
list of 'District' on second spinner depending on selection of
particular 'State' in the first spinner.
Example: Suppose when I select Karnataka in the first spinner then
application first retrieve all the district from SQLite database
related to karnataka state and then it display on second Spinner.
For this I do all the database activity correctly means creating two
table 'state' and 'district' in which one column in district table is
foreign key which is refereed to one of the primary key of 'state
table'
db.execSQL(create table +STATE_TABLE+ (+
STATE_ID+ integer primary key
autoincrement not null, +
STATE_NAME+ text+));
db.execSQL(create table +DISTRICT_TABLE+ (+DISTRICT_ID+
integer primary key autoincrement not
null,+DISTRICT_NAME
+ text,+STATE_ID+ integer,
FOREIGN KEY(
+STATE_ID+) REFERENCES
+STATE_TABLE
+(+STATE_ID+)+));
Now in the Activity Class:
spinnerState = (Spinner)findViewById(R.id.spinner1);
spinnerDistrict = (Spinner)findViewById(R.id.spinner2);
stateList = new ArrayListString();
districtList = new ArrayListString();
**Suppose all the data are all ready stored in database.**
Now I need to retrieve all the 'State' data from database and add it
in the statelist which is ArrayList.
Cursor stateCursor = database.query(STATE_TABLE, new String[]
{STATE_ID, STATE_NAME},
null, null, null, null, STATE_NAME);
stateCursor.moveToFirst();
if(! stateCursor.isAfterLast()){
do{
int id = stateCursor.getInt(0);
String stateName = stateCursor.getString(1);
stateList.add(stateName);
}while(stateCursor.moveToNext());
}
stateCursor.close();
after this I create one ArrayAdapter and put this state list into
this.
spinnerState.setAdapter(new ArrayAdapterString(this,
android.R.layout.simple_spinner_item, stateList));
Next i put the following code in the activity class:
spinnerState.setOnItemSelectedListener(new
OnItemSelectedListener() {
@Override
public void onItemSelected(AdapterView? parent,
View v,
int pos, long id) {
}
@Override
public void onNothingSelected(AdapterView? arg0) {
// TODO Auto-generated method stub
}
});
**Now My problem is here:**
1. How I get the StateId for executing the select query for taking
all the district related to particular state.
2. How the adepter will generate for District.
3. where I put all these code.
Here what I need creating the districtList after getting the value
from state Spinner.
Similar Question which asked earlier in this website, what they do:
they already create two adapter for two spinner and then apply
setOnItemSelectedListener.
Please Help me because here my mind totally stop working.
I refer lot of book and website but not they even mention these type
of problem.
--
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
--
Thanks and regards.
Mani.
--
You received this message because you are subscribed to the Google
Groups Android Developers group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
