I have a GridView which has a number of columns bound to several numeric properties (ints, doubles, or so). In my business object I use the extremal number "-1" to represent a "null" value in these numeric properties. That means that if the value is -1, then the property is unknown, not set.
How could I force my columns to treat -1 values as Null values? I need the filter mode set to Value, and SortMode set to Default as well, to let users useing the numeric specific capabilities. I use CustomDisplayText event for replacing -1 values with empty strings, however I still see the -1 in the filter popup for example, and also sorting takes -1 as it is, instead of null.
Is your intention to post an answer to your own question?
- If so, then proceed.
- If you simply wanted to post additional information, ask for further clarification, or to just say "Thanks!", please click Leave a Comment.
- If you wish to edit your original question, please use the Edit button in the Toolbox at the top right corner of that entry.