I have a list, which has a choice field with a number of options (e.g. Spring, Summer, Autumn, Winter).
These options appear in this order in the drop down list, but when I sort the list by this field, the items are sorted alphabetically, is there a way to change it easily, so that the list is ordered by the choice field and the items appear in the same order
as the choice options?
I am trying to do this programatically using the SPQuery, but any other solution would be welcome too.
I am displaying the data using SPGridView control.
View Complete Post