<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
DataSourceID="SqlDataSource1" DataTextField="NUMERO" DataValueField="NUMERO">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:IntranetConnectionString %>"
SelectCommand="SELECT DISTINCT[NUMERO] FROM [TELEPHONE] WHERE ([MATRICULE] = '<%# HttpContext.Current.User.Identity.Name.ToString() %>')">
<SelectParameters>
<asp:Parameter DefaultValue="ahijazi" Name="MATRICULE" Type="String" />
</SelectParameters>
</asp:SqlDataSource> |