Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I see a couple of solutions here:</p> <h2>Option 1:</h2> <p>Instead of declaring <code>stateList</code> as an <code>ArrayList&lt;String&gt;</code>, create a custom POJO <code>StateInfo</code> and designate stateList as <code>ArrayList&lt;StateInfo&gt;</code></p> <pre><code>public class StateList { private int id; private String stateName; //Constructors, getters and setters } </code></pre> <p>Then, </p> <pre><code>if(! stateCursor.isAfterLast()){ do{ int id = stateCursor.getInt(0); String stateName = stateCursor.getString(1); stateList.add(new StateInfo(id, stateName)); }while(stateCursor.moveToNext()); } </code></pre> <p>Now, you can do this:</p> <pre><code>public void onItemSelected(AdapterView&lt;?&gt; parent, View v, int pos, long id) { int id = stateList.get(pos).getId(); //Use This ID to construct your next SQLite query; and populate the district spinner. } </code></pre> <p>If you do this, you will have to create a custom <code>ArrayAdapter</code> and implement the <code>getView()</code> method. Look at the Android docs for how to do this.</p> <h2>Option 2:</h2> <p>Why do you even need the stateID? I suppose you can write a Query to get the districts list given a state Name only. In that case, you can retain the <code>stateList</code> as an <code>ArrayList&lt;String&gt;</code> and you don't even need the <code>StateInfo</code> class at all. Just do this:</p> <pre><code>public void onItemSelected(AdapterView&lt;?&gt; parent, View v, int pos, long id) { String stateName = stateList.get(pos); //Use this name to construct your next SQLite query; and populate the district spinner. } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POAndroid: value of one spinner depends on value of other spinner
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. UScurioustechizen
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POAndroid: value of one spinner depends on value of other spinner
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COPlus, since the list of districts for a state will not change during the execution of the program; you can preload a `HahMap` of `<stateName, districtList>` (one for each state) asynchronously at the program startup; or at least cache the values on first fetch. If you do this, you do not need to do additional queries when one state is selected; you can directly look into `HashMap` in `onItemSelected()`.
      singulars
      1. PO
      1. UScurioustechizen
    2. COthank you for quick response. but I am not able to write code for second spinner which show district. so please specify me full code for district spinner.
      singulars
      1. PO
      1. USVinit Vikash
    3. COWhere are you getting stuck? Are you able to write the query? Does it return the cursor for districts as expected? Please be more detailed so that we can help you.
      singulars
      1. PO
      1. UScurioustechizen
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload