Hey Dmitry,
Pretty easy really, as I'm sure you'll see once you look it up. You have two options, a new DataView, or the DefaultView of your current DataTable.
DataView MyView = new DataView(this.MyDataSet.Tables["MyTable"]);
DataView MyView = this.MyDataSet.Tables["MyTable"].DefaultView;
Then, set up the filter and set your DropDown's DataSource (I'm not sure what else needs setting, this is a web dropdown, and as you know, I'm not that web-savvy):
MyView.RowFilter = "the filter expression";
MyDropDown.DataSource = MyView;
~~Bonnie
>Hi Bonnie,
>
>This is how I approached the same task in VFP; loading the entire list of Buildings into a cursor and then filter it based on the user selection of Site. I will try to find an article on the web teaching how to filter DataView. I am jumping from .NET to VFP all the time and not very much up on how to do things in .NET.
>
>Thank very much for your suggestion.
>
>>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.