<%@ page language="VB" %>

<script runat="server">

    

</script>

<html>
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        &nbsp;&nbsp;
        <asp:DropDownList ID="lstCountries" Runat="server" DataValueField="Country" DataTextField="Country"
            DataSourceID="Countries" AutoPostBack="True">
        </asp:DropDownList>&nbsp;&nbsp;
        <asp:BulletedList ID="BulletedList1" Runat="server" DataSourceID="Contacts"
            DataTextField="ContactName" DataValueField="ContactName">
        </asp:BulletedList>
        <asp:SqlDataSource ID="Contacts" Runat="server" SelectCommand="SELECT ContactName FROM Customers WHERE Country=@Country"
            ConnectionString="Data Source=W2000;Initial Catalog=Northwind;Integrated Security=True">
            <SelectParameters>
                <asp:ControlParameter Name="Country" ControlID="lstCountries" PropertyName="SelectedValue">
                </asp:ControlParameter>
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="Countries" Runat="server" ConnectionString="data source=W2000;Integrated Security=SSPI;Initial catalog=Northwind"
            SelectCommand="SELECT DISTINCT Country FROM Customers">
        </asp:SqlDataSource>
    
    </div>
        &nbsp;&nbsp;&nbsp;
    </form>
</body>
</html>
