This is a migrated thread and some comments may be shown as answers.

[Solved] Checkbox field is required when using the grid to edit a non nullable bit field

7 Answers 118 Views

Grid

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

Brad Sumner asked on 13 May 2010, 10:27 PM

I'm getting an error ‘The [Column Name] field is required.’ when I try to update a non nullable bit field using the grid edit form. I can get it to work using a template column but it seems like using the standard Bound column method should allow you to check or un-check a checkbox without throwing the error. The error is getting thrown using client validation but I can’t figure out how to disable it and setting the bit column as nullable in the database will automatically use a dropdown list with the options of No Selection, True and False.

This method shows the error
columns.Bound(i => i.RegisterLargeTicket);

This method works
columns.Template(c => {
%>
<%=Html.CheckBox("RegisterLargeTicket", c.RegisterLargeTicket)%>
<%
});

Is there a way to disable the validation using columns.Bound so the checkbox either sends true or false or at least null so it can be handled server side? I tried using DataAnnotations and setting a default value for the property to false but that didn't work either.

Thanks for the hard work on developing the controls and making them open source!

Thanks,
Brad

7 Answers, 1 is accepted

answered on 14 May 2010, 04:03 PM

Thanks for the updated version. I'm still getting the validation error when using server binding and the format columns.Bound(i => i.RegisterLargeTicket); to bind the column.

In edit mode the following validation script is loaded on the page.

{"FieldName":"RegisterLargeTicket","ReplaceValidationMessageContents":true,"ValidationMessageId":"RegisterLargeTicket_validationMessage","ValidationRules":[{"ErrorMessage":"The RegisterLargeTicket field is required.","ValidationParameters":{}

Am I missing something that will turn off the client validation script for SQL bit/checkbox fields?

Thanks,
Brad