dropdown select item show the another grid

Question

My Aspx Code:



<div>
           
        <asp:DropDownList ID="DropDownList1" runat="server" Height="35px" Width="90px" OnSelectedIndexChanging="DropDownList1_SelectedIndexChanging">
            <asp:ListItem>Select</asp:ListItem>
            <asp:ListItem>School</asp:ListItem>
            <asp:ListItem>Collage</asp:ListItem>
            <asp:ListItem>Office</asp:ListItem>
        </asp:DropDownList>
           
        <asp:GridView ID="GridView1" runat="server">
        </asp:GridView>


           </div>

      I have one dropdownlist which contain value of  school and office i have also table in school and office i have also grid. when i select school in dropdownlist the grid display must the school table and vivice-versa.



Thank You,