The second dropdownlist is dependant on the first one.
Both columns are added as id fields in 3rd table, and both the columns have picklist data coming from there parent tables.
An alternative way would be to add the items to the Data Grid View Combo Box Column control directly, as shown: '---adding columns--- Data Grid View1.
Displaying a Combo Box in Cell Frequently, besides displaying text in a cell you may want to display a drop-down list box to allow users to select from a list of pre-determined values.
In this case, you need to add a Combo Box to the cells in the desired column.
Data Source = bindingsource '---add a combobox column to the Data Grid View control--- Data Grid View1. Add(combo Box Col) The previous code showed how you can bind a Binding Source control (containing a list of items to let the users choose) to a Data Grid View Combo Box Column control inside a Data Grid View control.
Add("Price", "Price") '---create a new bindingsource control--- Dim bindingsource As New Binding Source '---add the items into the control--- bindingsource. Header Text = "Types" '---data bind it--- combo Box Col.