[Solved] RadGrid with OpenAccess - not filtering on checkbox (bit field)

[Calsh]

Using RadGrid with OpenAccess - get error message as below when try to filter on checkbox column i.e. tick filter checkbox and select EqualTo.
(Using SQL Server 2008 and SiteStatus is a bit field)

Error is:

System.NotSupportedException: Execution of 'System.Nullable`1[[System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]:.ctor(Boolean)' on the database server side currently not implemented.

Code is:

<telerik:GridCheckBoxColumn DataField="SiteStatus" DataType="System.Boolean" FilterControlAltText="Filter Site Status column"
    HeaderText="Site Status" SortExpression="SiteStatus" UniqueName="SiteStatus"  DefaultInsertValue=""
    ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" >

    <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
    <ItemStyle HorizontalAlign="Center"></ItemStyle>
</telerik:GridCheckBoxColumn>

[Antonio Stoilkov]

Hello Colman,

It seems that the field in your database is Nullable. The GridCheckBoxColumn places a CheckBox control on the page which does not have a nullable state which prevents from binding it with nullable boolean types. You could achieve your scenario by placing a GridTemplateColumn and manually set the CheckBox Checked state and decide if the null value will equal true or false.

Regards,
Antonio Stoilkov
Telerik