combobox duplicate items

[John]

Hi,

I have an editable combobox in my databoundgrid that allows the user to type in 'one' or 'two'. When I open up the table, the combobox list is populated with several instances of 'one' and 'two' that I don't need. Is there a way to remove these duplicate items from the list? Thanks!

[haneefm]

Hi Coder12345,

You can handle the CurrentCellShowingDropDown event of the grid and remove the duplicated item using the gridComboBoxCellRenderer.ListBoxPart.Items.RemoveAt method. Here is a code snippet.

private void gridControl1_CurrentCellShowingDropDown(object sender, Syncfusion.Windows.Forms.Grid.GridCurrentCellShowingDropDownEventArgs e)
{
GridComboBoxCellRenderer cr =(GridComboBoxCellRenderer) this.gridControl1.CurrentCell.Renderer;
if(cr!=null)
{
for (int i = 0; i < cr.ListBoxPart.Items.Count; i++)
{
for (int j = 0; j < cr.ListBoxPart.Items.Count; j++)
{
if (i != j && cr.ListBoxPart.Items[i].Equals(cr.ListBoxPart.Items[j]))
{
cr.ListBoxPart.Items.RemoveAt(i);
i--;
break;
}
}
}
}
}

Best regards,
Haneef