我有一个网格视图,其中我的两个编辑模板字段都带有列表框。我需要从lotdownlist6中获取该值,并将其在dropdownlist1的sql连接字符串中使用。我已经尝试了我发现的每件事,但不能实现它,如果有人可以帮助我,我将非常感谢它。谢谢(:
<EditItemTemplate>
<asp:DropDownList ID="DropDownList6" runat="server" autopostback="true" >
<asp:ListItem>Any</asp:ListItem>
<asp:ListItem>Central</asp:ListItem>
<asp:ListItem>East</asp:ListItem>
<asp:ListItem>West</asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource4" DataTextField="roomCode" DataValueField="roomCode" DataKeyName="roomCode" AutoPostBack="true">
</asp:DropDownList>
</EditItemTemplate>
<asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:myConnectionString %>" SelectCommand="SELECT roomCode FROM [Room2] WHERE roomID NOT IN (SELECT roomID FROM [BookedRoom]) AND park=" **THIS IS WHERE I NEED THE VALUE** ">
</asp:SqlDataSource>
这是您使用SQLDATASOURCE CONTRORPARAMETER的位置。
来自此网站:
<p><asp:dropdownlist
id="DropDownList1"
runat="server"
autopostback="True">
<asp:listitem selected="True">Sales Representative</asp:listitem>
<asp:listitem>Sales Manager</asp:listitem>
<asp:listitem>Vice President, Sales</asp:listitem>
</asp:dropdownlist></p>
<asp:sqldatasource
id="SqlDataSource1"
runat="server"
connectionstring="<%$ ConnectionStrings:MyNorthwind%>"
selectcommand="SELECT LastName FROM Employees WHERE Title = @Title">
<selectparameters>
<asp:controlparameter name="Title" controlid="DropDownList1" propertyname="SelectedValue"/>
</selectparameters>
</asp:sqldatasource>
<p><asp:listbox
id="ListBox1"
runat="server"
datasourceid="SqlDataSource1"
datatextfield="LastName">
</asp:listbox></p>
请注意,数据源具有链接到下拉的控制参数。