Order by value in control
I have a baseball database with player name, position, and various hitting categories (e.g. home runs, runs, etc.). I have two drop down lists on a form - one is position, the other is hitting category. Let's say the user selects Catcher from the position drop down, and home runs from the category drop down.
I would like the resulting gridview to display all catchers in the database and their respective number of home runs, in descending order. So for the ORDER BY clause, how do I ORDER BY the value selected in the hitting category drop down control?