1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:intranetConnectionString %>"
DeleteCommand="DELETE FROM [infoaccueil] WHERE [idinfo] = @idinfo" InsertCommand="INSERT INTO [infoaccueil] ([date], [titre], [info]) VALUES ('<%# DateTime.Today.ToShortDateString(); %>', @titre, @info)"
SelectCommand="SELECT * FROM [infoaccueil] ORDER BY [idinfo] DESC" UpdateCommand="UPDATE [infoaccueil] SET [date] = @date, [titre] = @titre, [info] = @info WHERE [idinfo] = @idinfo">
<DeleteParameters>
<asp:Parameter Name="idinfo" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="date" Type="String" />
<asp:Parameter Name="titre" Type="String" />
<asp:Parameter Name="info" Type="String" />
<asp:Parameter Name="idinfo" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="idinfo" Type="Int32" />
<asp:Parameter Name="date" Type="String" />
<asp:Parameter Name="titre" Type="String" />
<asp:Parameter Name="info" Type="String" />
</InsertParameters>
</asp:SqlDataSource> |
Partager