I am trying to implement this functionality in a data entry form for my application.
The form will have a datagridview (dtgOffices) with 8 columns..
First column is a datagridviewtextboxcolumn, three datagridviewcombobox columns and another datagridviewtextboxcolumn, that will indicate if this is an existing office. The last columns are the dataentry text columns.
Onchange of value of the 1st column (Office ID), a datatable will be generated containing the records that will populate the 2nd (Region), 3rd (State),
and City (4th) comboboxes. When a Region is selected from the drop-down, only the State belonging to that Region should be available in the State combobox .. and so on and so forth.
After, if no record for this ID, 5th column will have an "N".
I was able to add a first row (Region only, for now, will take take of the rest once resolved) for an exisitng office ID
But when I entered non-existent office ID on the 2nd row data entry, the Region combobox is still populated with item from the previous tax id.
This is my Code:
Dim bsOffice as new BindingSource
if dtOffice.rows.count > 0 then 'this is the datatable that has the Region, State, and Cith info for a particular office ID, office ID has multiple Regions, States and Cities
bsOffice.DataSource = dtOffice
Dim cboRegion As DataGridViewComboBoxColumn = DirectCast(dtgOffices.Columns("Region"), DataGridViewComboBoxColumn)
cboRegion.DisplayMember = "RegionName"
cboRegion.ValueMember = "RegionID"
cboRegion.DataSource = bsOffice
Else
bsOffice.DataSource = Nothing
Exit Sub
End If
The form will have a datagridview (dtgOffices) with 8 columns..
First column is a datagridviewtextboxcolumn, three datagridviewcombobox columns and another datagridviewtextboxcolumn, that will indicate if this is an existing office. The last columns are the dataentry text columns.
Onchange of value of the 1st column (Office ID), a datatable will be generated containing the records that will populate the 2nd (Region), 3rd (State),
and City (4th) comboboxes. When a Region is selected from the drop-down, only the State belonging to that Region should be available in the State combobox .. and so on and so forth.
After, if no record for this ID, 5th column will have an "N".
I was able to add a first row (Region only, for now, will take take of the rest once resolved) for an exisitng office ID
But when I entered non-existent office ID on the 2nd row data entry, the Region combobox is still populated with item from the previous tax id.
This is my Code:
Dim bsOffice as new BindingSource
if dtOffice.rows.count > 0 then 'this is the datatable that has the Region, State, and Cith info for a particular office ID, office ID has multiple Regions, States and Cities
bsOffice.DataSource = dtOffice
Dim cboRegion As DataGridViewComboBoxColumn = DirectCast(dtgOffices.Columns("Region"), DataGridViewComboBoxColumn)
cboRegion.DisplayMember = "RegionName"
cboRegion.ValueMember = "RegionID"
cboRegion.DataSource = bsOffice
Else
bsOffice.DataSource = Nothing
Exit Sub
End If