Can someone point me to the right direction? I need to have several comboboxes and text boxes.
Each combobox gets values from a separate table based on value of a previous combox (i.e. user selects a group, then subgroup, etc)
There is also a "Result" table that has fields for all comboboxes values and some text fields.
When user selects all comboboxes values, textboxes should be filled with corresponding data from Result table. When user clicks "Save" all values from comboboxes and textboxes should be written to a "Result" table.
All this is easy enough to do by writing code manually but I was asked to do it using databinding and I got confused. It seems that I have to bind the same combobox to 2 tables - one to get data from, one to write it to. Somehow that doesnt seem right.
Also it looks like I must create a lot of DataRelations.
Is there a straightforward way to do it? May be someone has a sample? I would appreciate any suggestions.
Each combobox gets values from a separate table based on value of a previous combox (i.e. user selects a group, then subgroup, etc)
There is also a "Result" table that has fields for all comboboxes values and some text fields.
When user selects all comboboxes values, textboxes should be filled with corresponding data from Result table. When user clicks "Save" all values from comboboxes and textboxes should be written to a "Result" table.
All this is easy enough to do by writing code manually but I was asked to do it using databinding and I got confused. It seems that I have to bind the same combobox to 2 tables - one to get data from, one to write it to. Somehow that doesnt seem right.
Also it looks like I must create a lot of DataRelations.
Is there a straightforward way to do it? May be someone has a sample? I would appreciate any suggestions.