谢谢大家帮助,集众人的智慧,我最终的实现方法如下:
<tr><td align=right>院系</td><td style="width: 190px">
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1"
DataTextField="depname" DataValueField="depid" Width="155px" >
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:stmConnectionString3 %>"
SelectCommand="SELECT [depid],[depname] FROM [T_DepartmentInfo]"></asp:SqlDataSource></td></tr>
</td><td align=right>专业</td><td style="width: 183px" >
<asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource2" DataTextField="majorname" DataValueField="majorname" Width="153px">
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:stmConnectionString4 %>"
SelectCommand="SELECT [majorname] FROM [T_MajorInfo] WHERE depid=@depid">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="depid" PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</td></tr>