1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
<asp:SqlDataSource
ID="SqlDataSourceEntreprise"
runat="server"
ConnectionString="<%$ ConnectionStrings:PDP %>"
DeleteCommand="DELETE FROM Entreprise WHERE idEntreprise = @idEntreprise"
SelectCommand="SELECT idEntreprise, Nom, Activite FROM Entreprise WHERE (ISNULL(Activite, '') LIKE '%' + @Activite + '%') AND (ISNULL(Nom, '') LIKE '%' + @Nom + '%') ORDER BY Nom">
<SelectParameters>
<asp:ControlParameter
ControlID="TextBoxActivite"
DefaultValue="%"
Name="Activite"
PropertyName="Text"
Type="String" />
<asp:ControlParameter
ControlID="TextBoxNom"
DefaultValue="%"
Name="Nom"
PropertyName="Text"
Type="String" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="Entreprise" Type="int32" />
</DeleteParameters>
</asp:SqlDataSource> |
Partager