1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| <tr class="ListRow">
<td class="CellCaption"><span class="LabelHeader">Collaborateur :</span></td>
<td class="CellValue"><span class="Label">
<asp:DropDownList ID="SEL_COMPETENCES_COLL" AutoPostBack=true
ToolTip="Liste des competences" runat="server" CssClass="Select"
DataSourceID="SqlDataSource3" DataTextField="lib_coll"
DataValueField="id_coll"
onselectedindexchanged="SEL_COMPETENCES_COLL_SelectedIndexChanged">
</asp:DropDownList></span></td>
</tr>
<asp:SqlDataSource ID="SqlDataSource3"
SelectCommand="select id_coll, prenom_coll||' '||nom_coll lib_coll FROM COLLABORATEUR where id_manager = (select distinct id_coll from collaborateur where lower(prenom_coll) = lower(TRIM( :prenom_manag )) and lower(nom_coll) = lower(TRIM( :nom_manag ))) "
ConnectionString="<%$ ConnectionStrings:MyDataBase %>"
ProviderName="<%$ ConnectionStrings:MyDataBase.ProviderName %>"
runat="server">
<SelectParameters>
<asp:ControlParameter Name="prenom_manag" ControlID="SEL_COMPETENCES_PRENOM" PropertyName="Text"/>
<asp:ControlParameter Name="nom_manag" ControlID="SEL_COMPETENCES_NOM" PropertyName="Text"/>
</SelectParameters>
</asp:SqlDataSource> |
Partager