<html>
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="ddlCountry" runat="server" DataSourceID="sds_Countries"
DataTextField="Country" DataValueField="Country" AutoPostBack="True">
</asp:DropDownList>
<asp:SqlDataSource ID="sds_Countries" runat="server"
ConnectionString="<%$ ConnectionStrings:mgoloisConnectionString %>"
SelectCommand="SELECT Distinct [Country] FROM [ContactForm] ORDER BY [Country]">
</asp:SqlDataSource>
<asp:GridView ID="GridViewPeople" runat="server" AutoGenerateColumns="False"
DataSourceID="sds_People">
<Columns>
<asp:BoundField DataField="FirstName" HeaderText="FirstName"/>
<asp:BoundField DataField="LastName" HeaderText="LastName"/>
<asp:BoundField DataField="Email" HeaderText="Email" />
<asp:BoundField DataField="Address" HeaderText="Address" />
<asp:BoundField DataField="City" HeaderText="City"/>
<asp:BoundField DataField="State" HeaderText="State" />
<asp:BoundField DataField="Country" HeaderText="Country"/>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="sds_People" runat="server"
ConnectionString="<%$ ConnectionStrings:mgoloisConnectionString %>"
SelectCommand="SELECT [FirstName], [LastName], [Email], [Address],
[City], [State], [Country] FROM [ContactForm]
WHERE ([Country] = @Country) ORDER BY [LastName]">
<SelectParameters>
<asp:ControlParameter ControlID="ddlCountry" Name="Country"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>