62,244
社区成员




<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues" //ConflictDetection是啥?
ConnectionString="<%$ ConnectionStrings:pubconn %>" DeleteCommand="DELETE FROM [authors] WHERE [au_id] = @original_au_id AND [city] = @original_city" //@original_au_id是指啥?哪里来的?
InsertCommand="INSERT INTO [authors] ([au_id], [city]) VALUES (@au_id, @city)"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [au_id], [city] FROM [authors] ORDER BY [au_id]" <--original {0}是占哪个的占位符啊--> UpdateCommand="UPDATE [authors] SET [city] = @city WHERE [au_id] = @original_au_id AND [city] = @original_city">
<DeleteParameters>
<asp:Parameter Name="original_au_id" Type="String" />
<asp:Parameter Name="original_city" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="city" Type="String" />
<asp:Parameter Name="original_au_id" Type="String" />///这里的Parameter Name 有啥用?可以打乱顺序么?
<asp:Parameter Name="original_city" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="au_id" Type="String" />
<asp:Parameter Name="city" Type="String" />
</InsertParameters>
</asp:SqlDataSource>