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 ...
AK-47
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