SQLite getting data

Question

I have a spinner widget and I want to populate some data when user clicks on one of the items from spinner. So I have the position number like 0,1,2,3... for spinner items.

Now I have a table which have three fields as

  _id    cid    relatedname

   1       1          A
   2       1          B
   3       2          C
   4       2          D
   5       2          E

I want when a user clicks position 1 from spinner then it will check for cid and all the relatedname will be displayed whose cid is 1.

How to do this ?

what is your problem? querying the table or knowing when the selected element has changed? — hage
– hage, Commented Nov 29, 2011 at 9:47
how can i relate position and cid .how to iterate through cid and get realtedname. — Sunny
– Sunny, Commented Nov 29, 2011 at 9:50

Hiral Vadodaria · Accepted Answer · 2011-11-29 10:45:16Z

2

setOnItemChangelistener() to spinner then do as follows in tat listener.

loadRelatedName(position + 1);    

void loadRelatedName(int cid) 
{
     sql = " SELECT * FROM table WHERE cid = " + cid;
     Cursor c = db.select(sql);
     if (c ! null)
        while(c.moveToNext()) {
            Syso("Related Name : " + c.getString[2]);
     }
}

edited Nov 29, 2011 at 10:45

Hiral Vadodaria

19.3k5 gold badges42 silver badges56 bronze badges

answered Nov 29, 2011 at 10:11

Jayabal

3,6193 gold badges26 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

hage · Accepted Answer · 2011-11-29 10:05:26Z

0

Add a OnItemSelectedListener to the spinner to get the selected item.

See this

There you can get the position. With that you can query your database. Probably something like:

SELECT relatedname from mytable where cid=<selectedpos>

This will get you all entries where cid has the same value as the selected position. Note: It may be that the indexes of the spinner are zero based and cid is not. So maybe you need to add 1 to the selected position before querying the table

answered Nov 29, 2011 at 10:05

hage

6,2133 gold badges36 silver badges46 bronze badges

Collectives™ on Stack Overflow

SQLite getting data

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related