ASP.NET高级开发datasource控件

当选中dropdownlist的值时在通过datasource控件在GridView控件中显示其所对应的数据 

<asp:SqlDataSource ID="SqlDataSource2" runat="server"
            ConnectionString="<%$ ConnectionStrings:studentConnectionString4 %>"
            SelectCommand="SELECT * FROM [Classes]"></asp:SqlDataSource>

        <br />

        <asp:DropDownList ID="DropDownList3" runat="server" AutoPostBack="True"
            DataSourceID="SqlDataSource2" DataTextField="name" DataValueField="id">
        </asp:DropDownList>
        <br />
        <br />

        <asp:SqlDataSource ID="SqlDataSource3" runat="server"
            ConnectionString="<%$ ConnectionStrings:studentConnectionString5 %>"
            SelectCommand="SELECT [sid], [sname], [classid], [sex], [age], [photo] FROM [student] WHERE ([classid] = @classid)">
            <SelectParameters>
                <asp:ControlParameter ControlID="DropDownList3" Name="classid"
                    PropertyName="SelectedValue" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <br />
       

 <asp:GridView ID="GridView1" runat="server" AllowPaging="True"
            AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="sid"
            DataSourceID="SqlDataSource3">
            <Columns>
                <asp:CommandField ShowSelectButton="True" />
                <asp:BoundField DataField="sid" HeaderText="sid" InsertVisible="False"
                    ReadOnly="True" SortExpression="sid" />
                <asp:BoundField DataField="sname" HeaderText="sname" SortExpression="sname" />
                <asp:BoundField DataField="classid" HeaderText="classid"
                    SortExpression="classid" />
                <asp:BoundField DataField="sex" HeaderText="sex" SortExpression="sex" />
                <asp:BoundField DataField="age" HeaderText="age" SortExpression="age" />
                <asp:BoundField DataField="photo" HeaderText="photo" SortExpression="photo" />
            </Columns>
        </asp:GridView>