I'd also use a DataView of your Buildings DataTable instead of the DataTable itself for you Buildings drop-down, that way it's easy to filter it in the Site drop-down's event handler.
~~Bonnie
>Hi,
>
>I have a drop-down list of Buildings on a web page. Currently a dataset of buildings is created in the PAGE_LOAD method. Then (still in the PAGE_LOAD) the drop-down list is bound to the dataset.
>
>Now I need to add a Site drop-down list and in the Building drop-down list view only buildings that belong to a site (after user selects a site). Building table has SITE_NO field so that based on the user selection of Site drop-down I can determine which buildings to retrieve from the Buildings table. My question is what method should I use to create a dataset of buildings and bind it to the Building drop-down? I suppose this should be done in one of the methods of the Site drop-down, right? Which one?
>
>Any suggestions would be greatly appreciated.