Hi,

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?

Thanks.

SQL ordering is done this way:

ORDER BY firstfield [asc|desc], secondfield[asc|desc], etc...

You'll need to get the value from the DDL (ddl.SelectedValue) and pass it to the query that gets the data.

-Peter