Question about Gridcontrol boolean value format

Hi all.

I am using a Gridcontrol to display data read from access database. What I need is to make the program be able to display boolean value both in checkbox and textbox format.

The True/False value can differ from different settings, for instance it can be Y/N, Ja/Nee etc.

I have not problem with checkbox by setting the checkbox options.

The problem is for textbox, it seems only recoginize True/False to be valid value, it shows empty cell when I use other strings like Y/N.

What I did is add the columns by increasing the "colcount" property, and set the cellValueType to be bool.

How can I configure the textbox so that it also displays corresponding True/False values in other format?

Thanks a lot for your help!

Kun

Hi Kun,

Please try the code below in the QueryCellFormattedText event handler, this helps in formatting things as you like for boolean values in textbox cells.

private void gridControl1_QueryCellFormattedText(object sender, GridCellTextEventArgs e)
{
    if(e.Style.CellValueType == typeof(bool) && e.Style.CellType == "TextBox")
    {
        if(e.Value.ToString() == "True")
            e.Text = "Yes";
        else
            e.Text = "No";
        e.Handled = true;
    }
}

Let me know if this helps.
Thanks,
Rajagopal