checkbox cell does not work

I have GridGroupingControl form, want to show column "IsSupperSection" as checkbox. "IsSupperSection" column is numeric field (Not a boolean field). I used following code to set the column celltype. The checkbox does not display "CHECKED" for value other than 0; I clike the CheckBox, nothing happens. any idea? // ... load data gdBase.DataSource = mGridDataSet.Tables["MyTable"]; gdBase.TableDescriptor.Columns.LoadDefault(); string ColumnName="IsSupperSection"; this.gdBase.TableDescriptor.Columns.[ColumnName].Appearance.AnyRecordFieldCell.CellType ="CheckBox"; this.gdBase.TableDescriptor.Columns[ColumnName].Appearance.AnyRecordFieldCell.ShowButtons=GridShowButtons.ShowCurrentCell;

You will also need to set teh CheckBoxOptions so the grid knows what values you are using for Checked and Unchecked. GridStyleInfo style = this.gridGroupingControl1.TableDescriptor.Columns["check"].Appearance.AnyRecordFieldCell; style.CellType ="CheckBox"; style.CheckBoxOptions = new GridCheckBoxCellInfo("1", "0", "", true); //use 1 and 0 for values

Thanks Clay. My code works now. >I have GridGroupingControl form, want to show column "IsSupperSection" as checkbox. "IsSupperSection" column is numeric field (Not a boolean field). I used following code to set the column celltype. The checkbox does not display "CHECKED" for value other than 0; I clike the CheckBox, nothing happens. > >any idea? > > >// ... load data >gdBase.DataSource = mGridDataSet.Tables["MyTable"]; >gdBase.TableDescriptor.Columns.LoadDefault(); >string ColumnName="IsSupperSection"; >this.gdBase.TableDescriptor.Columns.[ColumnName].Appearance.AnyRecordFieldCell.CellType ="CheckBox"; >this.gdBase.TableDescriptor.Columns[ColumnName].Appearance.AnyRecordFieldCell.ShowButtons=GridShowButtons.ShowCurrentCell; >