I want to choose a country from that drop down list and If I click on the go button, then I want another query which can compare the country name(which I have selected) with another table and load the other necessary info from that table.

<p>
For Example: I have a dropdown list in my page which can load country list from a SQL database table. Now, I want to choose a country from that drop down list  and If I click on the go button, then I want another query which can compare the country name(which I have selected) with another table and load the other necessary info from that table. If I specify the country name on the SQL command , then the data loads nicely(

<asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>"
                              ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>" SelectCommand="SELECT [Zone_Name], [Ca ...