Convert from smallint (from datatable) to grid checkbox column

[Technology]

Dear Telerik team,

i have a datatable (from SQL) column "enable" with data type smallint. The values of this column are "0" & "1".
The grid, shows the rows of this column like "0" & "1".
I want to change this column to CheckboxColumn and when the value is 0=unchecked and 1=checked.

How can i do that??
Thank you in advance for your help.

Best Regards,
Navarino Technology Department

[Richard Slade]

Helo technology,

If you are creating the columns manually, you can just follow this documentation. Otherwise, if you have auto generated columns, I personally would change my SQL to output a boolean value rather than a tinyint. The RadGeridView will automatically pick this up and change the editor to a checkbox in this case.

Hope that helps, but let me know if you need more information.
Richard

[Richard Slade]

And another example for you in this forum link

[Technology]

Thank you for your quick support.
I changed the SQL data type from tinyint to bit and the grid shows the column as checkbox.

[Richard Slade]

Glad that helped.
All the best
Richard