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 26 27 28 29 30 31 32 33 34 35
|
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DG_BDD %>"
SelectCommand="SELECT * FROM [Actu1] WHERE ([Num] = @Num)" OldValuesParameterFormatString="original_{0}" ConflictDetection="CompareAllValues"
DeleteCommand="DELETE FROM [Actu1] WHERE [Num] = @original_Num AND [Date] = @original_Date AND [Cat] = @original_Cat AND [Bref] = @original_Bref AND [Corps] = @original_Corps"
InsertCommand="INSERT INTO [Actu1] ([Date], [Cat], [Bref], [Corps]) VALUES (@Date, @Cat, @Bref, @Corps)"
UpdateCommand="UPDATE [Actu1] SET [Date] = @Date, [Cat] = @Cat, [Bref] = @Bref, [Corps] = @Corps WHERE [Num] = @original_Num AND [Date] = @original_Date AND [Cat] = @original_Cat AND [Bref] = @original_Bref AND [Corps] = @original_Corps" >
<SelectParameters>
<asp:QueryStringParameter DefaultValue="1" Name="Num" QueryStringField="NumActu"
Type="Int32" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="original_Num" Type="Int32" />
<asp:Parameter Name="original_Date" Type="DateTime" />
<asp:Parameter Name="original_Cat" Type="String" />
<asp:Parameter Name="original_Bref" Type="String" />
<asp:Parameter Name="original_Corps" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Date" Type="DateTime" />
<asp:Parameter Name="Cat" Type="String" />
<asp:Parameter Name="Bref" Type="String" />
<asp:Parameter Name="Corps" Type="String" />
<asp:Parameter Name="original_Num" Type="Int32" />
<asp:Parameter Name="original_Date" Type="DateTime" />
<asp:Parameter Name="original_Cat" Type="String" />
<asp:Parameter Name="original_Bref" Type="String" />
<asp:Parameter Name="original_Corps" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="Date" Type="DateTime" />
<asp:Parameter Name="Cat" Type="String" />
<asp:Parameter Name="Bref" Type="String" />
<asp:Parameter Name="Corps" Type="String" />
</InsertParameters>
</asp:SqlDataSource> |