根据特定行的另一列设置特定单元格的组合框的数据源

Question

private void dgGrid_CellListSelect(object sender, CellEventArgs e)
{
    if (e.Cell.Column.Key == "ColumnA")
    {
        UltraGridRow selectedItem = ((UltraCombo)e.Cell.EditorControlResolved).SelectedRow;

        if (selectedItem != null)
        {
            //Option A
            cmbColumnB.DataSource = GetUISender<someBF>().RetrieveData(dataset).dataTable;
            cmbColumnB.DataBind();

            //Option B
            //((UltraCombo)e.Cell.Row.Cells["ChipSetID"].EditorControlResolved).DataSource = GetUISender<someBF>().RetrieveData(dataset).dataTable;
        }

    }
}

有一个允许数据网格添加新行的按钮。这个数据网格有2列，并且这两列都是UltraCombo。ColumnB combobox的dataSource将基于ColumnA。根据上面的代码，如果数据网格只有1行，但一旦用户添加了另一行，两行的ColumnB将共享相同的DataSource。

如何确保ColumnB的DataSource保持独立而不影响其他行?很明显，这是因为每一行都共享相同的组件，即cmbColumnB，但我不确定如何删除引用

Answer 1

我已经找到了解决方案，即每次创建一个新的UltraCombo并将其绑定到特定单元的EditorControl

private void dgGrid_CellListSelect(object sender, CellEventArgs e)
{
    if (e.Cell.Column.Key == "ColumnA")
    {
        UltraGridRow selectedItem = ((UltraCombo)e.Cell.EditorControlResolved).SelectedRow;

        if (selectedItem != null)
        {
            UltraCombo cmbValue = new UltraCombo();
            cmbValue.LimitToList = true;
            cmbValue.DropDownStyle = UltraComboStyle.DropDownList;
            cmbValue.DataSource = GetUISender<someBF>().RetrieveData(dataset).dataTable;
            cmbValue.ValueMember = someDS.someDT.someColumnIDColumn.ColumnName;
            cmbValue.DisplayMember = someDS.someDT.someColumnDescriptionColumn.ColumnName;
            cmbValue.BindingContext = someDg.BindingContext;
            cmbValue.DataBind();
            e.Cell.Row.Cells["ColumnB"].EditorControl = cmbValue;
            e.Cell.Row.Cells["ColumnB"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

        }

    }
}