Default Check Box Value

[Chad Elliot]

I have a GridDataBoundGrid that has a check box column. The column it is bound to only accepts 1 and 0. If I do not click the check box and try to save the row, I get an error saying that the column does not allow null values. Is there a way to set a default value for the check box column so that when new records are added, it will have a value of 0?

[Administrator]

Hi Chad, Please try setting the CheckBoxOptions property for the checkboxcolumn in the grid, see if this helps. grid.Binder.InternalColumns["CheckBoxColumn"].StyleInfo.CellType = "CheckBox"; grid.Binder.InternalColumns["CheckBoxColumn"].StyleInfo.CheckBoxOptions = new GridCheckBoxCellInfo("1", "0", DBNull.Value.ToString(), true); Please refer to the forum thread below, http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=18606 Refer to KnowledgeBase(KB) article below, for the details on CheckBoxOptions property. http://www.syncfusion.com/support/kb/grid/Default.aspx?ToDo=view&questId=28 Let us know if you need any further assistance. Regards, Rajagopal

[Chad Elliot]

I tried that and it does not work in my case. I have a data grid that is loaded with the contents of a single table. One column is a bit column, which does not allow NULL values and has a default of 0. The code that updates the data uses the SqlComandBuilder object to build the insert, update, and delete statements based on the select statement (SELECT * FROM [Table]). When the user enters a new row in the data grid, the value for the check box column in the dataset is NULL, but when the record is inserted into the SQL table, the column is populated with the default value of 0. If the user tries to change the record they just added, the update fails because the value of the check box column in the data set is not the same as the value in the SQL table. I need a way to default the check box column to 0 in the data set so subsequent updates to the record will work.

[Administrator]

Hi Chad,

Please set the AllowDBNull property to false for the checkbox column in the table and also set the DefaultValue for it to 0.

this.dataSet11.Tables[0].Columns["CheckboxCol"].AllowDBNull = false;
this.dataSet11.Tables[0].Columns["CheckboxCol"].DefaultValue = 0;

this.grid.DataSource = this.dataSet11.Tables[0];

Let us know if this helps.

Thanks,
Rajagopal