drop down duplicate items

[John]

Hi,

When I load the databoundgrid, there are duplicate items in the drop down list. How do I remove them? 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