I am using an EnhancedList to display the contents of a BO.
When trying to sort the columns in the grid, sorting does not work correctly for numeric columns. Also when enabling filtering, filter conditions like <, >, <=, >= do not work correct either with numeric columns. It looks like the EnanhancedList makes all columns of type string.
Is there a way to overcome this so that filtering works ok?
Thank you
One thing you can do though, is sort the BO before you populate the list instead of relying the grid to sort the columns. So before you call the Requery method on the list, set the sort of the BO and then load. You can populate a BO on the form or user control, then within the List, use the CopyDataFrom method. Then in the ListPopulating event of the EnhancedList, pass the BO that is populated and sorted. This will then load the list as you would like.