Dropdown to Trigger Custom Query from Database

[Anthony Bollinger]

I know, at least in principle, how to put all of the code on one page,
reference the text/value of a drop-down control and create a custom query.
However, I am using the code-behind model where I am setting the DataSource
of my DataList to a PagedDataSource object so I can do data paging. I am
totally stuck on how to generate the custom query using parameters. First,
how do I reference the value of the control "behind the page". The second
problem is probably more for me, how to write a custom query for the
PagedDataSource, but both issues are related in my mind.

Thanks for any suggestions,
Tony