1 2 3 4
|
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:cn_web_portal %>"
DeleteCommand='DELETE FROM "ACTU" WHERE "CODE_ACTU" = :CODE_ACTU' InsertCommand='INSERT INTO "ACTU" ("CODE_ACTU", "TITRE1", "CHAPEAU", "CORPS1", "OWNER1", "DATE_PUBLICATION") VALUES (:CODE_ACTU1, :TITRE1, :CHAPEAU1, :CORPS1, :OWNER1, :DATE_PUBLICATION1)' ProviderName="<%$ ConnectionStrings:cn_web_portal.ProviderName %>" SelectCommand='SELECT CODE_ACTU, TITRE1, CHAPEAU, CORPS1, OWNER1, DATE_PUBLICATION, VALIDE FROM ACTU WHERE (VALIDE = 0) ORDER BY DATE_PUBLICATION asc'
UpdateCommand='UPDATE "ACTU" SET "TITRE1" = :TITRE1, "CHAPEAU" = :CHAPEAU, "CORPS1"= :CORPS1, "OWNER1" = :OWNER1, "DATE_PUBLICATION" = :DATE_PUBLICATION WHERE "CODE_ACTU" = :CODE_ACTU'> |
Partager