We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Default Check Box Value

Thread ID:

Created:

Updated:

Platform:

Replies:

43707 May 1,2006 11:48 AM May 3,2006 05:23 AM Windows Forms 3
loading
Tags: GridControl
Chad Elliot
Asked On May 1, 2006 11:48 AM

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 [Syncfusion]
Replied On May 2, 2006 03:26 AM

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
Replied On May 2, 2006 08:45 AM

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 [Syncfusion]
Replied On May 3, 2006 05:23 AM

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

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;