Format the list items from the DataGridViewComboBox

Question

Hello,

I'm displaying prices on a DataGridView (on a WinForms application developped in C# on VS 2008). The column type is DataGridViewComboBoxColumn.

The DefaultCellStyle.Format property for this column is set to "C2" and the prices are indeed formatted as currency in the cells of this column.

However, when the user clicks the ComboBox to selected a value, the value on the list are not formatted. For example, instead of seeing:

3.90 €
4.50 €
5.95 €

They see

3.9
4.5
5.95

The values is also left-aligned while I would prefer to have them right-aligned.

Here is a picture showing the current behaviour and we can clearly see that it doesn't look as great as it could.

Is it possible to get the result I'm after?

Thanks.

Answer 1

Just handle the EditingControlShowing event on your DataGridView and do:

void dataGridView1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
{
    ComboBox cb = e.Control as ComboBox;
    if (cb != null)
        cb.FormatString = "<your format string>"; // e.g. "C2"
}