dd.Connection = OleDbConnection1 dd.CommandText = "insert into qingjia (name,reason,reasoncont,bgtime,overtime,tianshu,zhuangtai,sqtime) values (" & "'" & Lbname.Text & "','" & Dpreason.SelectedValue & "','" & Txcont.Text & "','" & DateVal

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/03 02:33:04

dd.Connection = OleDbConnection1 dd.CommandText = "insert into qingjia (name,reason,reasoncont,bgtime,overtime,tianshu,zhuangtai,sqtime) values (" & "'" & Lbname.Text & "','" & Dpreason.SelectedValue & "','" & Txcont.Text & "','" & DateVal
dd.Connection = OleDbConnection1
dd.CommandText = "insert into qingjia (name,reason,reasoncont,bgtime,overtime,tianshu,zhuangtai,sqtime) values (" & "'" & Lbname.Text & "','" & Dpreason.SelectedValue & "','" & Txcont.Text & "','" & DateValue(Text2.Value) & "','" & DateValue(Text1.Value) & "','" & Txday.Text & "','" & "未完成审批" & "'," & Now & ")"
dd.ExecuteNonQuery()
程序提示“语法错误 (操作符丢失) 在查询表达式 '2014-02-12 16:53:19' 中.”大概知道是" & Now & "这个地方不对,但是解决不了!~~~~~~

dd.Connection = OleDbConnection1 dd.CommandText = "insert into qingjia (name,reason,reasoncont,bgtime,overtime,tianshu,zhuangtai,sqtime) values (" & "'" & Lbname.Text & "','" & Dpreason.SelectedValue & "','" & Txcont.Text & "','" & DateVal
改成如下试试:
.& "未完成审批" & "',#" & Now & "#)"