I'm having a edit form on a database table. Let call the table products. On of the field is it's variety, this kan be easily achived with a lookup combo. But another field is sub-variety (not every product is a subvariety), the combo box of this field should be filtered by the variety selected. On what object (the combo-box, the binding source) should i use which event to start this kind of filtering ...
Kids Regards
What even to use ...
Bob Hicks
hi,
1) you can use dataview and you can sort or filter your table will be something like that
DataView myDv = new DataView(MyDataSet.Tables["mytableName"], "ColumNameToFilterByitsValue = 'stringvalue' and MyotherColumnNameToFilterByitsValue like '%wildcardfilter%' and MyothercolumNameToFilterByItsValue < intValue", "MyColumnNameThatIuseToSortBy", DataViewRowState.CurrentRows);mybindingSource.DataSource = myDv;
this.comboBox1.DataSource = mybindingSource;2) bindingsource control has a filter property you can use to filter your table records something like
bindingSource1.Filter =
"mycolumnName = value";hope this helps