Rank: Newbie
Groups: Member
Joined: 12/25/2008
Posts: 8
|
Hi,
I have a strange issue with the grid column with GridColumnDataType set to Boolean, the grid display 0 or 1 in the column instead of True or False. As per .Net documentation there is no data format provider for Boolean so what should I put in the DataFormat to render True or False?
Ho and yes I did check my data source an it a Boolean field.
Thanks.
|
Rank: Administration
Groups: Administration
Joined: 5/27/2007
Posts: 24,196
|
Hi,
The Grid does not display True or False because those two words are culture dependent, so internally the Grid always use "0" to represent false and "1" to represent true. If you wish to display true/false without allowing user to change it, you can either use a CustomColumn and handle the CustomColumn's ClientSideGetText event, or use a StaticColumn but returns "True" and "False" from your data source directly (for example, use SELECT IIF(your_bool_field, 'True', 'False') in your SQL instead of use SELECT your_bool_field directly.
Hope this helps. Please feel free to let us know if you have any more questions.
Thanks!
|