Hi,
I am VERY,VERY new to asp-ado and need some help please.

I want to put a dropdown box on my page with all the different countries as options. The user can then choose the country he wants to view and I want to then
select * from table where country = "the country the user picked from the dropdown"

My problem is how to get whatever the user selected into a variable which I can then use in my sql query

Thank you,