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]='" + _dotime +
"',[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);
还是报错啊,第一行附近语法错误:在sql查询器中显示的是UPDATE [dbo].[C_Work_Object] Set [Obj_name]='',[Obj_tid]='0',[Obj_sex]='0',[Obj_idcard]='',[Obj_xueli]='0',[Obj_birthday]='0001-1-1 0:00:00',[Obj_address]='',[Obj_biradd]='',[Obj_domethod]='',[Obj_caseid]='',[Obj_casetype]='',[Obj_casecode]='',[Obj_dostep]='0',[Obj_dotime]='0001-1-1 0:00:00',[Obj_finaltime]='0001-1-1 0:00:00',[Obj_memo]='',[Obj_doperson]='',[Obj_qianke]='0',[Obj_job]='',[Obj_doteam]='',[Obj_optime]='getdate() where Obj_id='0'小弟不才,没有找出错误在哪里??哪位大狭帮忙指点一下啊??谢谢~~~
" [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]='" + _dotime +
"',[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);
还是报错啊,第一行附近语法错误:在sql查询器中显示的是UPDATE [dbo].[C_Work_Object] Set [Obj_name]='',[Obj_tid]='0',[Obj_sex]='0',[Obj_idcard]='',[Obj_xueli]='0',[Obj_birthday]='0001-1-1 0:00:00',[Obj_address]='',[Obj_biradd]='',[Obj_domethod]='',[Obj_caseid]='',[Obj_casetype]='',[Obj_casecode]='',[Obj_dostep]='0',[Obj_dotime]='0001-1-1 0:00:00',[Obj_finaltime]='0001-1-1 0:00:00',[Obj_memo]='',[Obj_doperson]='',[Obj_qianke]='0',[Obj_job]='',[Obj_doteam]='',[Obj_optime]='getdate() where Obj_id='0'小弟不才,没有找出错误在哪里??哪位大狭帮忙指点一下啊??谢谢~~~
解决方案 »
- asp.net AspXGridView 自带CheckBox显示时为什么是问号
- DataTable 绑定 DataGridView 删除记录问题 windowForm 程序
- 能否修改控件禁用时的颜色?
- 使用类时出现错误提示"嵌入的语句不能是声明或标记语句"
- 如何将数据库数据通过xml形式export成一个ms project 文件?
- 关于windows phone 8.0连接sqlite数据库的问题,跪求大神救命。。。
- 短信发送问题
- 关于TreeView绑定数据之后怎样编辑里面的数据?
- 高手救命啊!我用adapter的update方法来实现DataGrid中的数据修改,测试时用sqlclient正常,换成oledb就不行了。我百思不得其解……
- 关于C#网络开发,该如何入门,如有好的书籍,也可推荐一下,谢谢!
- 知了急急律令——牛鬼蛇神请进:ClickOnce按需更新的问题
- 关于fileStream读和写的一些基本问题......
应该是
,[Obj_optime]=getdate() where Obj_id='0'
多了个'
" [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]='" + _dotime +
"',[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);
这里的 "getdate() where Obj_id=" 好象没有错吧???
----->
"',[Obj_optime]=" +
"',[Obj_finaltime]='" + _finaltime + 我已经在前面定义 private DateTime _dotime;
private DateTime _finaltime;类型的了,怎么还会报从 char 数据类型到 datetime 数据类型的转换导致 datetime 值越界的错误啊?怎么改啊???
你要是日期想填空的话就给个''或是null就行.
"',[Obj_finaltime]='" + _finaltime +
改为 "',[Obj_dotime]='" + null+
"',[Obj_finaltime]='" null+ 吗??
或[Obj_finaltime]=null, null插进去就是null你最好不要拼接sql,最好用参数化来做:)
不过你要确定你的表中字段允许为空
这样看眼晕的了