help binding a dataset

[Jake Smythe]

Hello,


I have a dataset that contains companyid, company name, projectid,
project name. I want to bind the dataset to two combo boxes and make the
second dependant on the first. So the first combo box would contain the
companies and depending on what the user selected the second combo box would
populate just the projects for that company. How would I go about doing this
with the one dataset? How would I avoid repeating company names in the first
combo box, if this is possible? Thanks in advance.

Jake

 

[Guest]

Hello,


I have a dataset that contains companyid, company name, projectid,
project name. I want to bind the dataset to two combo boxes and make the
second dependant on the first. So the first combo box would contain the
companies and depending on what the user selected the second combo box would
populate just the projects for that company. How would I go about doing this
with the one dataset? How would I avoid repeating company names in the first
combo box, if this is possible? Thanks in advance.

Jake

I would keep the data in two seperate datatables (both of which can be
in the dataset, but that isn't important) Then bind one combobox to one
table and use the selectionchange event to bind the second using
datatable.select to fill in the second.

Chris

 

[Cor Ligthert [MVP]]

Jake,

Probably you would think by binding the "value" propety from the first to
the text "property" from the second, I thought that I have never succeeded
in that..

Maybe can you use this to do it. (that it is a datagrid is not important in
this sample)

This one is three deep.

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

I hope this helps,

Cor