Use a checkbox for editing if you have 1/0 values in the database
How can I use a checkbox for editing if I have 1/0 values in my database?
Templates are used to extend the built-in appearance and functionality of the columns.
A column can use templates for view mode and also for edit mode.
You need to use something like this in the SQL statement:
SELECT some_field=(CASE your_bit_field WHEN 1 THEN 'true' ELSE 'false' END)
Use "some_field" for the DataField property of the Column
The true/false values will be used on the client-side by the grid
to check/uncheck the checkbox when you edit a record.
Make sure you replace true/false (grid value)
with 1/0 (database values) in the method that updates the database.