1 2 3 4 5 6 7 8 9 10
| <asp:AccessDataSource
ID="CategoryArtBDD"
runat="server"
DataFile="~/App_Data/BDD.mdb"
SelectCommand="SELECT [TYPE_REF_FOURN], [TYPE_ART_LIB], [TYPE_ART_PV_HT], [TYPE_ART_PV_TTC], [CAT_ID], [CON_RS], [TYPE_ART_IMG] FROM [TYPE_ARTICLE], [CONSTRUCTEUR] WHERE (([CAT_ID] = ?) AND ([TYPE_ART_TYP] = ?) AND ([CONSTRUCTEUR].CON_ID=[TYPE_ARTICLE].CON_ID)) ORDER BY [TYPE_ART_PV_TTC]">
<SelectParameters>
<asp:QueryStringParameter Name="CAT_ID" QueryStringField="CAT_ID" DefaultValue="ordinateurs portables" Type="String"/>
<asp:Parameter Name="TYPE_ART_TYP" DefaultValue="actuel" Type="String"/>
</SelectParameters>
</asp:AccessDataSource> |
Partager