[問題] ASP.NET C# 資料庫SELECT問題
小的我是非常非常新的新手，希望各位強人救救我
想請教一個問題，我設計了4個dropdownlist，也順利的抓到了值
我想要把抓到的值作為datalist的查詢條件
但不管怎麼弄，selectcommand就是不理我
以下是我的程式碼，請問一下各位大大我哪裡錯了??
<form id="form1" runat="server">
<div>
棟別:
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="AccessDataSource2"
DataTextField="BUILDING" DataValueField="BUILDING_NAME" AppendDataBoundItems="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
<asp:ListItem></asp:ListItem>
</asp:DropDownList><asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/op.mdb"
SelectCommand="SELECT * FROM [棟別]"></asp:AccessDataSource>
<br />
樓層: <asp:DropDownList ID="DropDownList2" runat="server" AppendDataBoundItems="True" DataSourceID="AccessDataSource3"
DataTextField="FLOOR" DataValueField="FLOOR" OnSelectedIndexChanged="DropDownList2_SelectedIndexChanged">
<asp:ListItem></asp:ListItem>
</asp:DropDownList><asp:AccessDataSource ID="AccessDataSource3" runat="server" DataFile="~/op.mdb"
SelectCommand="SELECT * FROM [樓層]"></asp:AccessDataSource>
<br />
單位: <asp:DropDownList ID="DropDownList3" runat="server" AppendDataBoundItems="True" DataSourceID="AccessDataSource4"
DataTextField="DEP_CODE" DataValueField="DEP_DEPARTMENT_NAME" OnSelectedIndexChanged="DropDownList3_SelectedIndexChanged">
<asp:ListItem></asp:ListItem>
</asp:DropDownList><asp:AccessDataSource ID="AccessDataSource4" runat="server" DataFile="~/op.mdb"
SelectCommand="SELECT * FROM [單位]"></asp:AccessDataSource>
<br />
用途:
<asp:DropDownList ID="DropDownList4" runat="server" AppendDataBoundItems="True" DataSourceID="AccessDataSource5"
DataTextField="SYSTEM" DataValueField="SYSTEM_NAME" OnSelectedIndexChanged="DropDownList4_SelectedIndexChanged">
<asp:ListItem></asp:ListItem>
</asp:DropDownList><asp:AccessDataSource ID="AccessDataSource5" runat="server" DataFile="~/op.mdb"
SelectCommand="SELECT * FROM [用途]籾"></asp:AccessDataSource>
<br />
<br />
<br />
<br />
<asp:DataList ID="DataList1" runat="server" DataKeyField="識別碼" DataSourceID="AccessDataSource1">
<ItemTemplate>
霅咓锑蝣
<asp:Label ID="霅咓锑蝣Label" runat="server" Text='<%# Eval("霅咓锑蝣?) %>'></asp:Label><br />
BUILDING:
<asp:Label ID="BUILDINGLabel" runat="server" Text='<%# Eval("BUILDING") %>'></asp:Label><br />
FLOOR:
<asp:Label ID="FLOORLabel" runat="server" Text='<%# Eval("FLOOR") %>'></asp:Label><br />
DEP:
<asp:Label ID="DEPLabel" runat="server" Text='<%# Eval("DEP") %>'></asp:Label><br />
SYSTEM:
<asp:Label ID="SYSTEMLabel" runat="server" Text='<%# Eval("SYSTEM") %>'></asp:Label><br />
NUMBER:
<asp:Label ID="NUMBERLabel" runat="server" Text='<%# Eval("NUMBER") %>'></asp:Label><br />
NOTE:
<asp:Label ID="NOTELabel" runat="server" Text='<%# Eval("NOTE") %>'></asp:Label><br />
<br />
</ItemTemplate>
</asp:DataList>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/op.mdb"
SelectCommand="SELECT * FROM TABLE WHERE BUILDING = @BUILDING_NAME "
>
<SelectParameters>
<asp:ControlParameter
PropertyName="SelectedValue"
ControlID="DropDownList1"
Type="string"
Name="BUILDING_NAME"
/>
</SelectParameters>
</asp:AccessDataSource>
<br />
<br />
<br />
<br />
<asp:Button ID="Button1" runat="server" Text="查詢" OnClick="Button1_Click" /><br />
</div>
</form>
拜託各位大大了>"<
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 163.15.161.238
※ 編輯: evan1112 來自: 163.15.161.238 (11/27 16:21)
推
11/27 16:21, , 1F
11/27 16:21, 1F
→
11/27 16:22, , 2F
11/27 16:22, 2F
→
11/28 02:03, , 3F
11/28 02:03, 3F
→
11/28 09:07, , 4F
11/28 09:07, 4F
→
11/29 11:09, , 5F
11/29 11:09, 5F
→
11/29 11:09, , 6F
11/29 11:09, 6F