Hierarchical lists in DropDownLists

[p.mc]

Hi all,

I'm writing an image cataloguing system in asp.net and SQLserver. The
system allows hierarchical keywords to be added to the image records.

I've represented the keywords in tables with 'id' and 'text' fields for
each keyword. The table of second level keywords also has a 'parentID'
field linking it to one keyword from the first level.

I am successfully displaying both levels of keywords in ddl's in a
datagrid but I now want to filter the second level values based on the
image id of selected first level keyword.

The dropdownlists are bound to Dataviews so I guess filtering the
dataview is the correct way to go? What's the best way of going
about this? and how can I reload the values in the second list after
changing the selected value in the level one ddl?

Thanks in advance for any help,

Paul

[clickon]

This page explains how to do it quite well.

http://www.webswapp.com/codesamples/...s/default.aspx

"p.mc" wrote:

Hi all,

I'm writing an image cataloguing system in asp.net and SQLserver. The
system allows hierarchical keywords to be added to the image records.

I've represented the keywords in tables with 'id' and 'text' fields for
each keyword. The table of second level keywords also has a 'parentID'
field linking it to one keyword from the first level.

I am successfully displaying both levels of keywords in ddl's in a
datagrid but I now want to filter the second level values based on the
image id of selected first level keyword.

The dropdownlists are bound to Dataviews so I guess filtering the
dataview is the correct way to go? What's the best way of going
about this? and how can I reload the values in the second list after
changing the selected value in the level one ddl?

Thanks in advance for any help,

Paul