Is there a setting to tell the grid to sort differently? When I click the column to sort this is the outcome of an integer field. It seems as if it is only looking at the first digit in the number and not the number as a whole?
TIA,
-Ted
13
17
21
25
38
42
8
Hello Ted,
I believe that this is due to the fact that your coulmn's datatype is 'System.String' and not 'Int' or 'Decimal' for example. So the WinGrid control is comparing these 'digits' as strings actually. Please change the datatype to Int16 for example and try this again.
Thank you for the response Boris. This makes sense to me. My issue is I get an error saying cannot change datatype of a bound field. I don't think I'll be able to change the column datatype unless you know of an override I can do or a way around?
Thanks,
Ted