Private rs As New ADODB.Recordset
Private cData As New CDataBase
打开数据库
sql = "update worktime set work_time with '" + "5:00"+ "'"+ "where Userid='" + txtid.Text + "'"
rs.Open sql, cData.db
老是出错,,给高手给出答案把,,,,,
Private cData As New CDataBase
打开数据库
sql = "update worktime set work_time with '" + "5:00"+ "'"+ "where Userid='" + txtid.Text + "'"
rs.Open sql, cData.db
老是出错,,给高手给出答案把,,,,,
解决方案 »
- 有二个问题困扰了我很久,望各位同仁帮助
- 急!急! 关于vb c/s 结构作 火车票销售系统的 问题 在线等待。。。。(100分,如果不够可再加分)
- 关于webbrowser控件自动登陆的问题,80分
- 怎樣清除Listview中的內容和網格!!
- 请问怎么在程序中响应快捷键,如按F3键就弹出一个对话框......
- 请问如何用API编程实现鼠标,和键盘的加锁和解锁.
- 请教个很弱的问题!
- 鱼头,又有生意了!!
- 急!求救!!错误代码文3709连接无法用于执行此操作
- 谁能推荐几本好的VB EBOOK 下载,推荐给十分.
- 如何搜索rtf文件的内容?
- 菜鸟提问:怎样把图片存入sql server数据库,在vb中怎样显示出图片? 请高手赐教!!
cn.open ...sql = "update worktime set work_time = '" + "5:00" + "'" + " where Userid = '" + txtid.Text + "'"cn.execute sql
sql = "update worktime set work_time = " & "5:00" & " where Userid = '" & txtid.Text & "'"
& " where Userid = '" + txtid.Text + "'"
rs.execute sql
提醒在你有多条修改语句同时对库修改时,建议用事务来控制
dim rs as ADODB.Connection
set rs=new ADODB.Connection
如果是多用户环境建议用事务来完成
sql = "update worktime set work_time = '5:00' where Userid = '" & Trim(txtid.Text) & "'"
如果是你自己确定的参数,就不用去加"&"还是"+"了.
用 & 它+ 是 JAVA中的
cn.execute "update worktime set work_time with '" + "5:00"+ "'"+ "where Userid='" + txtid.Text + "'"
cn.execute "update worktime set work_time with '" & "5:00"+ "'" & "where Userid='" & txtid.Text & "'"