string sql = "UPDATE [dbo].[C_Work_Object] Set " +
"' [Obj_name]='" + _name +
"',[Obj_tid]='" + _tid +
"',[Obj_sex]='" + _sex +
"',[Obj_idcard]='" + _idcard +
"',[Obj_xueli]='" + _xueli +
"',[Obj_birthday]='" + _birthday +
"',[Obj_address]='" + _address +
"',[Obj_biradd]='" + _biraddr +
"',[Obj_domethod]='" + _domethod +
"',[Obj_caseid]='" + _caseid +
"',[Obj_casetype]='" + _casetype +
"',[Obj_casecode]='" + _casecode +
"',[Obj_dostep]='" + _dostep +
"',[Obj_dotime]='" + _finaltime +
"',[Obj_finaltime]='" + _finaltime +
"',[Obj_memo]='" + _memo +
"',[Obj_doperson]='" + _doperson +
"',[Obj_qianke]='" + _Qianke +
"',[Obj_job]='" + _job +
"',[Obj_doteam]='" + _doteam +
"',[Obj_optime]='" +
"getdate() where Obj_id=" +
"'" + _tid + "'";
this.dbProcessor.ExecuteSql(sql);
报错::第 1 行: ' [Obj_name]=',[Obj_tid]=' 附近有语法错误。哪位大狭帮指出啊???谢谢~~
"' [Obj_name]='" + _name +
"',[Obj_tid]='" + _tid +
"',[Obj_sex]='" + _sex +
"',[Obj_idcard]='" + _idcard +
"',[Obj_xueli]='" + _xueli +
"',[Obj_birthday]='" + _birthday +
"',[Obj_address]='" + _address +
"',[Obj_biradd]='" + _biraddr +
"',[Obj_domethod]='" + _domethod +
"',[Obj_caseid]='" + _caseid +
"',[Obj_casetype]='" + _casetype +
"',[Obj_casecode]='" + _casecode +
"',[Obj_dostep]='" + _dostep +
"',[Obj_dotime]='" + _finaltime +
"',[Obj_finaltime]='" + _finaltime +
"',[Obj_memo]='" + _memo +
"',[Obj_doperson]='" + _doperson +
"',[Obj_qianke]='" + _Qianke +
"',[Obj_job]='" + _job +
"',[Obj_doteam]='" + _doteam +
"',[Obj_optime]='" +
"getdate() where Obj_id=" +
"'" + _tid + "'";
this.dbProcessor.ExecuteSql(sql);
报错::第 1 行: ' [Obj_name]=',[Obj_tid]=' 附近有语法错误。哪位大狭帮指出啊???谢谢~~
应该是
update table set name='',id=1不是字段加''而是value要加''
另外要注意你的数据的类型,不会说你的数据都是字符型的吧