Binding mellem to datakontroller
HejJeg har senarie:
En combobox der udfra en SQLdataSource viser indholdet af en branche tabel.
En DataList der udfra en anden SQLdataSource skal vise de kunder der er i den valgte branche.
Jeg har defineres det hele, men kan ikke finde ud af hvorfor min Dataliste ikke "køres" / viser de fundne data?
Kode:
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Colliers_CRMConnectionString %>"
SelectCommand="SELECT * FROM [CRM_Branche] ORDER BY [Branche]">
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:Colliers_CRMConnectionString %>"
SelectCommand="SELECT [KOBNummer] FROM [CRM_Kunde] WHERE ([BrancheId] = @BrancheId)">
<SelectParameters>
<asp:ControlParameter
ControlID="DropDownList1"
Name="BrancheId"
PropertyName="SelectedValue"
Type="Object"
/>
</SelectParameters>
</asp:SqlDataSource>
<asp:DropDownList ID="DropDownList1" runat="server"
AutoPostBack="True"
DataSourceID="SqlDataSource1"
DataTextField="Branche"
DataValueField="BrancheId"
Style="z-index: 100; left: 205px; position: absolute; top: 110px"
Width="295px">
</asp:DropDownList>
<asp:DataList ID="DataList1" runat="server"
BorderColor="Black" BorderWidth="1px" CellPadding="4"
DataSourceID="SqlDataSource2" ForeColor="#333333" GridLines="Both"
Style="z-index: 101; left: 20px; position: absolute; top: 165px">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<SelectedItemStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<ItemTemplate>
KOBNummer:
<asp:Label ID="KOBNummerLabel" runat="server" Text='<%# Eval("KOBNummer") %>'></asp:Label><br />
<br />
</ItemTemplate>
</asp:DataList>
</asp:Content>