Linking combobox columns in data grid VB.net

[alexmax2003]

That quotation was add b4 i need to know from VB.Net wizards The answer
"I'm trying to use a datagrid for data entry. I've created a couple of combo
box columns using information from
http://64.78.52.104/FAQ/WinForms/FAQ_c44c.asp#q4 80q

That example basically sets every combobox in a given column (for every row)
to the same datasource.
One obstacle I have to overcome is when a user changes a value in one
column, the next combobox in the next column on the same row needs to bind to
a new set of data, and only for that row. For example, Column A is Cost
Centers, Column B is Job Codes. If I select a Cost Center from Column A, the
combo in Column B needs to list only valid Job Codes for the previously
selected Cost Center, on a row-by-row basis.

Any idea how to do this, or is there a sample somewhere someone could point
me to?
Thanks

[alexmax2003]

18. How do I have a combo box column display a sub set of data based upon the value of a different combo box column?
Sometimes data that you want to display in the DataGridView has a relationship between two tables such as a category and subcategory. You want to let the user select the category and then choose between a subcategory based upon the category. This is possible with the DataGridView by using two combo box columns. To enable this, two versions of the filtered list (subcategory) needs to be created. One list has no filter applied while the other one will be filtered only when the user is editing a subcategory cell. Two lists are required due to the requirement described in 3.5.1 section that a combo box cells value must be in the items collection or else a DataError event is raised. In this case, since all combo box cells in the column use the same datasource if you filter the datasource for one row then a combo box cell in another row might not have its value visible in the datasource, thus causing a DataError event.

The below example uses the Northwind database to display related data from the Territory and Region tables (a territory is in a specific region.) Using the category and subcategory concept, the Region is the category and the Territory is the subcategory.

private void Form1_Load(obje ct sender, EventArgs e)
{
this.territorie sTableAdapter.F ill(this.northw indDataSet.Terr itories);
this.regionTabl eAdapter.Fill(t his.northwindDa taSet.Region);

// Setup BindingSource for filtered view.
filteredTerrito riesBS = new BindingSource() ;
DataView dv = new DataView(northw indDataSet.Tabl es["Territorie s"]);
filteredTerrito riesBS.DataSour ce = dv;

}

private void dataGridView1_C ellBeginEdit(ob ject sender,
DataGridViewCel lCancelEventArg s e)
{
if (e.ColumnIndex == territoryComboB oxColumn.Index)
{
// Set the combobox cell datasource to the filtered BindingSource
DataGridViewCom boBoxCell dgcb = (DataGridViewCo mboBoxCell)data GridView1
[e.ColumnIndex, e.RowIndex];
dgcb.DataSource = filteredTerrito riesBS;

// Filter the BindingSource based upon the region selected
this.filteredTe rritoriesBS.Fil ter = "RegionID = " +
this.dataGridVi ew1[e.ColumnIndex - 1, e.RowIndex].Value.ToString ();
}
}

private void dataGridView1_C ellEndEdit(obje ct sender, DataGridViewCel lEventArgs e)
{
if (e.ColumnIndex == this.territoryC omboBoxColumn.I ndex)
{
// Reset combobox cell to the unfiltered BindingSource
DataGridViewCom boBoxCell dgcb = (DataGridViewCo mboBoxCell)data GridView1
[e.ColumnIndex, e.RowIndex];
dgcb.DataSource = territoriesBind ingSource; //unfiltered

this.filteredTe rritoriesBS.Rem oveFilter();
}
}