UPDATE WH_HUIZONG
SET details = '" 2009 "'
WHERE (item = 'year'),
SET details = 'dianshichang'
WHERE (item = 'department')
提示","附近语法错误,请问怎样修改呢?
SET details = '" 2009 "'
WHERE (item = 'year'),
SET details = 'dianshichang'
WHERE (item = 'department')
提示","附近语法错误,请问怎样修改呢?
string str = "update WH_HUIZONG set details='" + b + "' where item=year,department='" + dw + "',zj_num=(select zj_num from FM_total where year='" + b + "'AND department= '" + dw + "'),yg_num=(select yg_num from FM_total where year='" + b + "'AND department= '" + dw + "'),score=(select score from FM_total where year='" + b + "'AND department= '" + dw + "')
SqlCommand cmd = new SqlCommand(string.Format(str), con);
SET details = '" 2009 "'
WHERE (item = 'year'), SET details = 'dianshichang'
WHERE (item = 'department')
你这个要改成
UPDATE WH_HUIZONG
SET details = '" 2009 "'
WHERE (item = 'year')UPDATE WH_HUIZONG
SET details = 'dianshichang'
WHERE (item = 'department')
/* 必须分开. 如果你的where条件一样的话*/
UPDATE WH_HUIZONG
SET details = '" 2009 "' ,
details = 'dianshichang',
字段='值'--(最后一个要更新的字段的逗号要去掉)
WHERE (item = 'department')
SET details =case when item='year' then '2009' else 'dianshichang' end
ACCESSUPDATE WH_HUIZONG
SET details =iif(item='year','2009','dianshichang')
如果是其他数据库,我也不知道了
非常感谢!可是这就要写很多行update了,我把这些都放到了
SqlCommand cmd = new SqlCommand(string.Format(str), con);里边,str只能代表一句话,我能在里边改成str1,str2,str3这样的形式么,还是要写多个这样的语句?
"exec('" + str + "')"
SqlCommand cmd = new SqlCommand(string.Format(str), con);里边,str只能代表一句话,我能在里边改成str1,str2,str3这样的形式么,还是要写多个这样的语句?
--------------------------------------------------------
一个str表示,多条命令用分号隔开就行了
cmd.CommandText = str2;
然后再次cmd.ExecuteNonQuery()进行更新,
有多少句SQL语句就改变多少次CommandText后执行cmd.ExecuteNonQuery()更新。另外这是是针对通用数据库而言的,如果你是SQLSERVER里的操作(好像就是,不然怎么用SqlCommand),那么你可以多条语句写在一起,各个语句之间封号隔开,然后一次性赋值给cmd.CommandText后提交更新。
SqlCommand cmd1 = new SqlCommand(string.Format(str), con);
SqlCommand cmd2 = new SqlCommand(string.Format(str), con);
...
请问是这么写么?