Hi, After chaining getChildrenCursor(Cursor groupCursor)as
protected Cursor getChildrenCursor(Cursor groupCursor)
{
System.out.println ("Inside getChildrenCursor");
String roomname =
groupCursor.getString(groupCursor.getColumnIndex("RoomName"));
System.out.println ("@@#...@#@#...@#"+idVal);
Cursor groupCursor1 = sampleDB.rawQuery ("SELECT
_id,SwitchFullName FROM SwitchTable where RoomName='"+roomname
+"'",null);
return groupCursor1;
}
it works well. THANK YOU Kostya.
On Dec 16, 1:34 pm, Kostya Vasilyev <[email protected]> wrote:
> 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
