Changing datasource of Combobox at runtime

[Kingsley]

How can I change the datasource of a combobox cell when is clicked. I tried the following code without success:

private void GDBG_CurrentCellActivated(object sender, System.EventArgs e)
{
if (GDBG.CurrentCell.ColIndex == 4)
{

GridComboBoxCellRenderer cr=(GridComboBoxCellRenderer)GDBG.CurrentCell.Renderer;

CurrencyManager cm = (CurrencyManager) this.BindingContext[GDBG.DataSource];

DataRow row = (DataRow) ((DataRowView) cm.Current).Row;

string ownertype = Convert.ToString(row["Descr"]);

string filter = "ContactGroup LIKE ''" + ownertype + "''";

oDS.Tables[2].Rows.Add(oDS.Tables[1].Select(filter));

cr.ListBoxPart.DataSource = oDS.Tables[2];

cr.ListBoxPart.ValueMember = "ContactTypeKey";

cr.ListBoxPart.DisplayMember = "ContactTypeDescription";
}

[Administrator]

Hi Kingsley,

Setting the DataSource for a ComboBox type cell in the CurrentCellActivated event handler works fine. The DataSource can also be set in the CurrentCellShowingDropDown event handler. Please check whether the oDS.Tables[1].Select(filter) in your code returns any row. The DropDown list part wont be shown when the DataSource is empty.

Regards,
Calvin.

[Kingsley]

You''re right, the problem is from the filter line. It''s ok now, Thanks

>Hi Kingsley,
>
>Setting the DataSource for a ComboBox type cell in the CurrentCellActivated event handler works fine. The DataSource can also be set in the CurrentCellShowingDropDown event handler. Please check whether the oDS.Tables[1].Select(filter) in your code returns any row. The DropDown list part wont be shown when the DataSource is empty.
>
>Regards,
>Calvin.