Pramod, getChildrenCursor is given a cursor.
You get the value of room name (or any other column) the same way, by calling methods of Cursor.
http://developer.android.com/reference/android/database/Cursor.html -- Kostya 16.12.2010 11:08, pramod.deore пишет:
Hi Kostya, Thanks I have change code like this: public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); sampleDB = this.openOrCreateDatabase(SAMPLE_DBNAME, MODE_PRIVATE, null); Cursor groupCursor = sampleDB.rawQuery ("SELECT _id, RoomName ,SwitchFullName FROM SwitchTable GROUP BY RoomName",null); System.out.println ("#######"+groupCursor.getCount()); System.out.println ("_____"+groupCursor.getPosition()); System.out.println (groupCursor.getColumnIndex("RoomName")); // Cache the ID column index mGroupIdColumnIndex = groupCursor.getColumnIndexOrThrow("_id"); //groupCursor.moveToFirst(); // Set up our adapter mAdapter = new MyExpandableListAdapter(groupCursor, this, android.R.layout.simple_expandable_list_item_1, android.R.layout.simple_expandable_list_item_2, new String[] {"RoomName"}, // Name for group layouts new int[] {android.R.id.text1}, new String[] {"SwitchFullName"}, // Number for child layouts new int[] {android.R.id.text1}); setListAdapter(mAdapter); System.out.println ("%%%% %"+getExpandableListAdapter().getGroupCount()); System.out.println ("::::::::::::::"+this.getSelectedId()); } Now I want name of parent (here name of room) on which user clicked. Because if I get name of room then I can use that in getChildrenCursor () as protected Cursor getChildrenCursor(Cursor groupCursor) { Cursor groupCursor1 = sampleDB.rawQuery ("SELECT _id,SwitchFullName FROM SwitchTable where RoomName = 'HERE GOES ROOM NAME'",null); //System.out.println ("#######"+groupCursor1.getCount()); return groupCursor1; } So how to get room name.Thanks On Dec 15, 4:55 pm, Kostya Vasilyev<[email protected]> wrote:15.12.2010 14:05, pramod.deore пишет:Hi every time I get _ID value as 1. I used following line to get value mGroupIdColumnIndex = groupCursor.getColumnIndexOrThrow("_id");That's the index of column "_ID" within your query, not the value stored in the database. http://developer.android.com/reference/android/database/Cursor.html#g...)And you told me that usethis is in where condition into following query. Cursor groupCursor1 = sampleDB.rawQuery ("SELECT DISTINCT RoomName AS RoomName1 ,_id , SwitchFullName FROM SwitchTable ORDER BY RoomName",null);See last parameter: http://developer.android.com/reference/android/database/sqlite/SQLite..., java.lang.String[]) Also: http://www.sqlite.org/lang_select.html#whereclause -- Kostya Vasilyev -- WiFi Manager + pretty widget --http://kmansoft.wordpress.com
-- Kostya Vasilyev -- WiFi Manager + pretty widget -- http://kmansoft.wordpress.com -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
