WEB 8.2.2

<%@ Page Language=“C#” AutoEventWireup=“true” CodeFile=“Default.aspx.cs” Inherits="_Default" %>

<form id="form1" runat="server">
    
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:zln02ConnectionString %>"
        SelectCommand="SELECT * FROM [Table] ">


        </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server"
        ConnectionString="<%$ ConnectionStrings:zln02ConnectionString %>"
        SelectCommand="SELECT * FROM [Table] where (Id=@IID)">

            <SelectParameters>

<asp:ControlParameter ControlID=“DropDownList1” Name=“IID” PropertyName=“SelectedValue” />

       </SelectParameters>
        </asp:SqlDataSource>
           
    <asp:DropDownList ID="DropDownList1"
        runat="server" 
        AutoPostBack="True" 
        DataSourceID="SqlDataSource1"
        DataTextField="Id" 
        DataValueField="Id"
        >
    </asp:DropDownList>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="SqlDataSource2">
        <Columns>
            <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" SortExpression="Id" />
            <asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
            <asp:BoundField DataField="address" HeaderText="address" SortExpression="address" />
        </Columns>
    </asp:GridView>
    <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
    <br />
</form>