views:

39

answers:

1

I have master-detail relationship. Basically I have a list of states and a list of towns per state.

I want for it to display something like

  • Oklahoma
  • > Tulsa
  • > Oklahoma City
  • Arizona
  • > Phoenix
  • > etc etc

and etc.

The city names and the state names are stored in different tables with each city containing a state_id

I am using SubSonic3(ActiveRecord) for querying. (using ObjectDataSource for databinding controls)

What would be the best way to do this in an ASP.Net page? The only ideas I can think of involve complicated nested databinding which I can't get to work.

+2  A: 

Hi,

Not sure how much at ease you will be with the following suggestions:

Using repeaters for displaying nested data: http://www.asp.net/data-access/tutorials/nested-data-web-controls-vb

Working with nested data: http://msdn.microsoft.com/en-us/library/aa478959.aspx

If you are to only display nested data and not edit/update it, repeaters might be good choice.

You could then use ul li tags for the layout of your choice.

Hope it helps!

Vaibhav