ado.net两个表更新数据

return false 2017-11-28 05:53:09

rt，
有一个界面，数据从mssql a表和b表过来
现在要更新界面中的所有数据，我是这么写的



string update = "update  ems_xp set a.property_num='" + this.资产.Value + "',a.Section_num='" + this.部门管理编号.Value + "',a.sn='" + this.序列号.Value + "',b.ip='" + this.IP地址.Value + "',b.mac='" + this.MAC.Value + "',b.hostname='" + this.电脑名.Value + "',a.model='" + this.型号.Value + "',a.type_s='" + this.类型.Value + "',a.Supplier='" + this.品牌.Value + "',a.cpu='" + this.CPU.Value + "',a.hdd='" + this.硬盘.Value + "',a.memory='" + this.内存.Value + "',a.statuss='" + this.资产状态.Value + "',a.takes='" + this.使用担当.Value + "',a.contact='" + this.联络员.Value + "',a.Acquire_date='" + this.取得日期.Value + "',a.update_time='" + this.更新日期.Value + "',a.position='" + this.位置.Value + "',a.is_null='" + this.资产有无.Value + "',a.is_num='" + this.有无标签.Value + "',b.floor='" + this.楼层.Value + "' from  ems_xp as a inner join macip as b on a.property_num=b.bh";

        SqlCommand cmd=new SqlCommand(update,strcon);

        cmd.ExecuteNonQuery();

结果报错：无法绑定由多个部分组成的标识符 "a.property_num"。
我这样写好像也只能更新a表的数据

请问各位大侠有什么方法么？

...全文

290 13 打赏收藏转发到动态举报

写回复

用AI写文章

13 条回复

切换为时间正序

请发表友善的回复…

发表回复

l35740623 2017-12-06

打赏
举报

把值传入存储过程来处理。但是，我觉得用事务会更好

lkf181 2017-12-01

打赏
举报

执行两次更新把，分别更新两张表..........

Hello World, 2017-12-01

打赏
举报

每条语句只能更新一个表，第两条语句更新，事务处理 update a set a.xx=xxxx from table1 a inner table2 b on a.id=b.xxx where xxxx update b set b.xx=xxxx from table1 a inner table2 b on a.id=b.xxx where ccc 另外，最好用参数化查询，不要拼字符串

兔子家族-二哥 2017-12-01

打赏
举报

如果 ems_xp 中包含 property_num 那么 1L 的写法其实就可以了，没必须一定加a ，你说不行，估计你要表达的意思都没说清楚

兔子家族-二哥 2017-12-01

打赏
举报

引用楼主 qq_23934571 的回复:

rt，有一个界面，数据从mssql a表和b表过来现在要更新界面中的所有数据，我是这么写的


string update = "update  ems_xp set a.property_num='" + this.资产.Value + "',a.Section_num='" + this.部门管理编号.Value + "',a.sn='" + this.序列号.Value + "',b.ip='" + this.IP地址.Value + "',b.mac='" + this.MAC.Value + "',b.hostname='" + this.电脑名.Value + "',a.model='" + this.型号.Value + "',a.type_s='" + this.类型.Value + "',a.Supplier='" + this.品牌.Value + "',a.cpu='" + this.CPU.Value + "',a.hdd='" + this.硬盘.Value + "',a.memory='" + this.内存.Value + "',a.statuss='" + this.资产状态.Value + "',a.takes='" + this.使用担当.Value + "',a.contact='" + this.联络员.Value + "',a.Acquire_date='" + this.取得日期.Value + "',a.update_time='" + this.更新日期.Value + "',a.position='" + this.位置.Value + "',a.is_null='" + this.资产有无.Value + "',a.is_num='" + this.有无标签.Value + "',b.floor='" + this.楼层.Value + "' from  ems_xp as a inner join macip as b on a.property_num=b.bh";
        SqlCommand cmd=new SqlCommand(update,strcon);
        cmd.ExecuteNonQuery();

结果报错：无法绑定由多个部分组成的标识符 "a.property_num"。我这样写好像也只能更新a表的数据请问各位大侠有什么方法么？

ems_xp as a

yzf86211861 2017-11-29

打赏
举报

学会调试 string update = "update ems_xp set a.property_num='" + this.资产.Value + "',a.Section_num='" + this.部门管理编号.Value + "',a.sn='" + this.序列号.Value + "',b.ip='" + this.IP地址.Value + "',b.mac='" + this.MAC.Value + "',b.hostname='" + this.电脑名.Value + "',a.model='" + this.型号.Value + "',a.type_s='" + this.类型.Value + "',a.Supplier='" + this.品牌.Value + "',a.cpu='" + this.CPU.Value + "',a.hdd='" + this.硬盘.Value + "',a.memory='" + this.内存.Value + "',a.statuss='" + this.资产状态.Value + "',a.takes='" + this.使用担当.Value + "',a.contact='" + this.联络员.Value + "',a.Acquire_date='" + this.取得日期.Value + "',a.update_time='" + this.更新日期.Value + "',a.position='" + this.位置.Value + "',a.is_null='" + this.资产有无.Value + "',a.is_num='" + this.有无标签.Value + "',b.floor='" + this.楼层.Value + "' from ems_xp as a inner join macip as b on a.property_num=b.bh"; 在这里加个断点 SqlCommand cmd=new SqlCommand(update,strcon); cmd.ExecuteNonQuery(); 把 update 添加监控，拿出来上面的 SQL 语句拿到 SQL 查询分析器里面执行一下看哪儿报错.

正怒月神版主 2017-11-29

打赏
举报

string update = "update  ems_xp a set a.property_num='" + this.资产.Value + "',a.Section_num='" + this.部门管理编号.Value + "',a.sn='" + this.序列号.Value + "',b.ip='" + this.IP地址.Value + "',b.mac='" + this.MAC.Value + "',b.hostname='" + this.电脑名.Value + "',a.model='" + this.型号.Value + "',a.type_s='" + this.类型.Value + "',a.Supplier='" + this.品牌.Value + "',a.cpu='" + this.CPU.Value + "',a.hdd='" + this.硬盘.Value + "',a.memory='" + this.内存.Value + "',a.statuss='" + this.资产状态.Value + "',a.takes='" + this.使用担当.Value + "',a.contact='" + this.联络员.Value + "',a.Acquire_date='" + this.取得日期.Value + "',a.update_time='" + this.更新日期.Value + "',a.position='" + this.位置.Value + "',a.is_null='" + this.资产有无.Value + "',a.is_num='" + this.有无标签.Value + "',b.floor='" + this.楼层.Value + "' from  ems_xp as c inner join macip as b on c.property_num=b.bh";
        SqlCommand cmd=new SqlCommand(update,strcon);
        cmd.ExecuteNonQuery();