i need a customized checkbox editor in editable datagrid, but don't know how.

[Jeffrey AnnSheila]

hi,i want to make a field to be a checkbox editor in an editable DataGrid . the underline data  stored in mysql is 1 or 0,and  i need the checkbox text show "yes" when the value is 1 and "no" when the value is 0. When i check "yes" the value should be 1 and send to mysql, check "no" will send value 0 too.
The demo is editor:{type:'checkbox',options:{on:"yes",off:"no"}}, but it doesn't work here. please help me resolve it.thanks.

[jarry]

Please try this code:

Code:

<th data-options="
        field:'status',
        width:60,
        align:'center',
        formatter:function(value){
            return value==1 ? 'yes' : 'no';
        },
        editor:{type:'checkbox',options:{on:'1',off:'0'}}
        ">Status</th>