I just upgraded to Telerik UI for WinForms 2014 from 2010.
I have an application with about 40 grids we build dynamically that have checkbox columns. Many of the tables feeding these grids have NULL values for the bit column. When applying a filter to a grid that has NULL values in the CheckBox column I get an error. If I modify my query using ISNULL(fieldname, 0) AS fieldname I am able to filter, but I can no longer update the bit field for that CheckBox column because it is now aliased.
Before the upgrade the filtering worked even if there were NULL values. What can I do to get both filtering and update capability on CheckBox columns that reference a bit column that contains NULL values. The underlying data cannot be changed to eliminate NULL values because a NULL represents a state other than true or false when handling data in our stored procedures.
This is the code used to create the CheckBox columns:
ElseIf objTab.Columns(i).DataType.Name = "Boolean" Then
Dim col As GridViewCheckBoxColumn = New GridViewCheckBoxColumn
col.Name = colname
col.FieldName = colname
col.HeaderText = colname
col.ReadOnly = Not (pCanWrite)
objGrd.Columns.Add(col)
I have an application with about 40 grids we build dynamically that have checkbox columns. Many of the tables feeding these grids have NULL values for the bit column. When applying a filter to a grid that has NULL values in the CheckBox column I get an error. If I modify my query using ISNULL(fieldname, 0) AS fieldname I am able to filter, but I can no longer update the bit field for that CheckBox column because it is now aliased.
Before the upgrade the filtering worked even if there were NULL values. What can I do to get both filtering and update capability on CheckBox columns that reference a bit column that contains NULL values. The underlying data cannot be changed to eliminate NULL values because a NULL represents a state other than true or false when handling data in our stored procedures.
This is the code used to create the CheckBox columns:
ElseIf objTab.Columns(i).DataType.Name = "Boolean" Then
Dim col As GridViewCheckBoxColumn = New GridViewCheckBoxColumn
col.Name = colname
col.FieldName = colname
col.HeaderText = colname
col.ReadOnly = Not (pCanWrite)
objGrd.Columns.Add(col)