I have a button that displays a portion of a SQL server table that uses a cursor adapter to display the information. What is the best way to requery the cursor and change the order to what ever the user wants? For instance, by default the displayed info is in date order. If the user wants it in quantity order how could I have a keypress (or something similar) accomplish this?

Thanks in advance
Kelly