DevForce Community Forum : order by in child collection http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : order by in child collection Tue, 14 Apr 2026 16:17:27 -700 Wed, 28 Nov 2007 12:38:43 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=563 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ order by in child collection : You can set up your nested grid... http://www.ideablade.com/forum/forum_posts.asp?TID=563&PID=2031#2031 Author: davidklitzke
Subject: 563
Posted: 28-Nov-2007 at 12:38pm

You can set up your nested grid by using "chained binding" or by using "event handlers".  The advantage of using "chained binding" (as shown in the "Populating a WinForm" tutorial) is that there is absolutely no code to write.  The disadvantage is that you have no control over how the EntityList for the detail grid is populated.  Therefore, you will need to use an Event Handler.
 
The Event Handler that you will need is for the CurrentChanged event on the BindingSource to which your primary grid is bound.  When the CurrentChanged event fires on the BindingSource, just build a new EntityList.  Build the EntityList using an OrderBy clause.  Note that your query will be asking for all detail objects that have a parent id equal to the id of the currently selected parent.
 
 


Edited by davidklitzke - 28-Nov-2007 at 12:50pm]]> Wed, 28 Nov 2007 12:38:43 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=563&PID=2031#2031 order by in child collection : I have an object with a child... http://www.ideablade.com/forum/forum_posts.asp?TID=563&PID=2027#2027 Author: Makani
Subject: 563
Posted: 28-Nov-2007 at 8:44am

I have an object with a child collection.  I have tied the child collection to a grid.  It is not apparent to me how to pass an order by to the hydration of this collection. Do I have to use an Rdb subquery if I want an ordered child collection?
 
]]> Wed, 28 Nov 2007 08:44:06 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=563&PID=2027#2027