62,025
社区成员
发帖
与我相关
我的任务
分享
<asp:SqlDataSource ID="sqldsCAddressListDetail" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:MySql %>" DeleteCommand="DELETE FROM [tongxunlu] WHERE [id] = @original_id AND [name] = @original_name AND [company] = @original_company AND [addr] = @original_addr AND [phone1] = @original_phone1 AND [phone2] = @original_phone2 AND [mobile] = @original_mobile AND [fax] = @original_fax AND [email] = @original_email AND [post] = @original_post AND [beizu] = @original_beizu AND [birthday] = @original_birthday AND [wangzan] = @original_wangzan"
InsertCommand="INSERT INTO [tongxunlu] ([name], [company], [addr], [phone1], [phone2], [mobile], [fax], [email], [post], [beizu], [birthday], [wangzan],[sf_public]) VALUES (@name, @company, @addr, @phone1, @phone2, @mobile, @fax, @email, @post, @beizu, @birthday, @wangzan,'yes')"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [id], [name], [company], [addr], [phone1], [phone2], [mobile], [fax], [email], [post], [beizu], [birthday], [wangzan] FROM [tongxunlu] where id = @paramID"
UpdateCommand="UPDATE [tongxunlu] SET [name] = @name, [company] = @company, [addr] = @addr, [phone1] = @phone1, [phone2] = @phone2, [mobile] = @mobile, [fax] = @fax, [email] = @email, [post] = @post, [beizu] = @beizu, [birthday] = @birthday, [wangzan] = @wangzan WHERE [id] = @original_id" OnInserted="sqldsCAddressListDetail_Inserted">
<DeleteParameters>
<asp:Parameter Name="original_id" Type="Int32" />
<asp:Parameter Name="original_name" Type="String" />
<asp:Parameter Name="original_company" Type="String" />
<asp:Parameter Name="original_addr" Type="String" />
<asp:Parameter Name="original_phone1" Type="String" />
<asp:Parameter Name="original_phone2" Type="String" />
<asp:Parameter Name="original_mobile" Type="String" />
<asp:Parameter Name="original_fax" Type="String" />
<asp:Parameter Name="original_email" Type="String" />
<asp:Parameter Name="original_post" Type="String" />
<asp:Parameter Name="original_beizu" Type="String" />
<asp:Parameter Name="original_birthday" Type="String" />
<asp:Parameter Name="original_wangzan" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="company" Type="String" />
<asp:Parameter Name="addr" Type="String" />
<asp:Parameter Name="phone1" Type="String" />
<asp:Parameter Name="phone2" Type="String" />
<asp:Parameter Name="mobile" Type="String" />
<asp:Parameter Name="fax" Type="String" />
<asp:Parameter Name="email" Type="String" />
<asp:Parameter Name="post" Type="String" />
<asp:Parameter Name="beizu" Type="String" />
<asp:Parameter Name="birthday" Type="String" />
<asp:Parameter Name="wangzan" Type="String" />
<asp:Parameter Name="original_id" Type="Int32" />
</UpdateParameters>
<SelectParameters>
<asp:QueryStringParameter Name="paramID" QueryStringField="id" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="company" Type="String" />
<asp:Parameter Name="addr" Type="String" />
<asp:Parameter Name="phone1" Type="String" />
<asp:Parameter Name="phone2" Type="String" />
<asp:Parameter Name="mobile" Type="String" />
<asp:Parameter Name="fax" Type="String" />
<asp:Parameter Name="email" Type="String" />
<asp:Parameter Name="post" Type="String" />
<asp:Parameter Name="beizu" Type="String" />
<asp:Parameter Name="birthday" Type="String" />
<asp:Parameter Name="wangzan" Type="String" />
</InsertParameters>
</asp:SqlDataSource>