ERROR: In filter menu, Number, Date and Boolean columns have incorrect operators

Problem

In filter menu, Number, Date and Boolean columns contain incorrect operators.

Solution               

The Grid can get the column’s data type from the first record of data source by default. When you bind the empty data source, Grid cannot find the actual data type of a column. In this case, you have to set the data type of the column explicitly. The available column data type is tabulated as follows.

Refer to the following code example to enable Type property in Grid.

The highlighted code in the following code example illustrates the customization of Column types. The code example explains about how to render the filter menu even when the database contain NULL values in certain records, and to render the date picker on edit mode without specifying the editType of the column.

JS

MVC

Controller

ASPX

ASPX.CS

The following screenshot illustrates the output.

Customized Grid