A datagrid ComboBoxes

[Guest]

Hi,

I have a datagrid with a combobox that contain the states of USA. And at his
right side there is another combobox with all the county of every state. Of
course both data (states and conties are stores in two tables respectively).

The question is, How can I show only the counties that belong to a state
depending on the state the user choose?

Thanks.

 

[Cor Ligthert [MVP]]

Robe,

You can do that by a datarelation or by faking that by using a dataview. The
last I prever.

Have a look at this sample on our site, that it is a datagrid and even 3
tables does not change the fun.

http://www.vb-tips.com/default.aspx?ID=cb1408ff-030d-4ea8-80b1-af26354b1fa0

With the combobox it is even much simpler.

I hope this helps,

Cor

 

[Cor Ligthert [MVP]]

Sorry,

It is inside the datagrid. That means that you need the datarelation.

Cor