Simulation of Access DB Lookup Table Type

[Guest]

I have several comboboxes on a form that are bound to the same dataset. I
want to simulate the Access Lookup Table in these comboboxes. That is, I can
select a value loaded in the combobox without changing the selected value in
another combobox that is bound to the same data. I have been reading about
CurrencyManagers but how could I use this to help? If it is possible at all.

 

[ssamuel]

It's certainly possible, but probably less likely with off-the-shelf
built-in automatic data binding. Usually, if you want to do something
like this, you need to do one or both of the following:

1. Uncouple from data binding and populate things manually. It's less
clean and pretty, involves more code, but can always get your job done.
List<> and Dictionary<> objects (ArrayList and Hashtable if you're in
1.1) provide rich data handling. You may also be able to create a typed
custom DataSet that contains some extra columns to drive your extra UI
elements.

2. Extend a data provider or provide your own. Your custom data
provider will contain all the methods and bindings you need to display
the data as you want it.

Either way, this looks like the perfect application to create your own
custom control. You may also be able to find a source repository that
has an existing control similar to this that you can use or extend.


Stephan