URGENT! VB.NET - Need To Populate A DataGridViewComboBoxColumn With Values From Another DataGridViewComboBoxColumn

I have a DataGridView which has four DataGridViewComboBox columns.  When the user selects the first DataGridViewComboBox column value, I want the second DataGridViewComboBox column to be filled based on the parameters sent  by the first DataGridComboBoxColumn. Likewise the same going from the second DataGridViewComboBox column to the third and then the third DataGridViewComboBox column to the fourth.

How should I get started?

Eric BurtonSr.ProgrammerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ess KayEntrapenuerCommented:
double click the first drop down

it should open a new function (on_changed_datagriddropdownsomething)

in that function, you will run code to populate the next drop down, based on


and so on

hope that helps
Jacques Bourgeois (James Burger)PresidentCommented:
DirectCast(dgv.Columns("NameOfDestinationColumn"), DataGridViewComboBoxColumn).DataSource = DirectCast(dgv.Columns("NameOfSourceColumn"), DataGridViewComboBoxColumn).DataSource
Eric BurtonSr.ProgrammerAuthor Commented:
Thanks for your input.  I decided to bind the column to a DataTable and use an OracleDataAdapter along with the DataGridView.CellEnter event to populate the DataGridViewComboBox.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jacques Bourgeois (James Burger)PresidentCommented:
The question was asked.

The question was answered.

And then he changes he tells us that finally he did not need our time.

This is a beautiful way of saying to "experts": do not answer my questions, you are losing your time.
Eric BurtonSr.ProgrammerAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.