Bindingnavigator not updating
In the first case it’s not necessary to set up a data relation in your Data Set between the lookup table and the table you’re editing, but it doesn’t hurt.
In the second case it is necessary to create a relation between your parent and child tables. First we’ll use the Data Source Configuration Wizard to create a Data Set with Regions and Territories.
Because of this I’m putting together a “how-to” video series on a variety of topics in this area.
Two of the videos are dedicated to data binding the Combo Box in a couple very common scenarios:1.
Data sources that are bound to a component can also be navigated and managed with the Binding Navigator class, which provides a VCR-like user interface (UI) for navigating items within a list.
Now let’s take our second scenario where we want to use the Combo Box as a row filter.
In this case we have to have a relation set up between our parent and our child; in the example this is FK_Territories_Region in our Data Set.
So we need to write some code: Because we have related Binding Sources the grid will automatically filter its rows based on the selected parent row in the Combo Box.
And notice that this code would work with other controls as well, for instance, instead of a Combo Box we could have used a List Box or have set up two related grids.