Form1.Data1.RecordSource = tempstr
Form1.Data1.Recordset.edit
Form1.Data1.Recordset.Fields(0) = name1
Form1.Data1.Recordset.Fields(6) = department
Form1.Data1.Recordset.Fields(7) = class
Form1.Data1.Recordset.Fields(4) = num
Form1.Data1.Recordset.Fields(1) = sex
Form1.Data1.Recordset.Fields(3) = area
Form1.Data1.Recordset.Fields(5) = minzu
Form1.Data1.Recordset.Fields(8) = address
Form1.Data1.Recordset.Fields(9) = code
Form1.Data1.Recordset.Fields(2) = bir
Form1.Data1.Recordset.Update Form1.Data1.Refreshname1,department,class是从text中取出来的字符串,个数有你的数据库表结构决定
还有,在这之前用recordsource="select * from ……"查询语句定位到你要修改的字符串还有,你没有分啊
Form1.Data1.Recordset.edit
Form1.Data1.Recordset.Fields(0) = name1
Form1.Data1.Recordset.Fields(6) = department
Form1.Data1.Recordset.Fields(7) = class
Form1.Data1.Recordset.Fields(4) = num
Form1.Data1.Recordset.Fields(1) = sex
Form1.Data1.Recordset.Fields(3) = area
Form1.Data1.Recordset.Fields(5) = minzu
Form1.Data1.Recordset.Fields(8) = address
Form1.Data1.Recordset.Fields(9) = code
Form1.Data1.Recordset.Fields(2) = bir
Form1.Data1.Recordset.Update Form1.Data1.Refreshname1,department,class是从text中取出来的字符串,个数有你的数据库表结构决定
还有,在这之前用recordsource="select * from ……"查询语句定位到你要修改的字符串还有,你没有分啊
解决方案 »
- combox与sql中的数据列绑定
- vb winsock的问题,怎样让服务器端知道客户端的连接已经关闭,以便关闭服务器端对应连接!
- Exchange server的配置
- 泪求和ocx,ddl,ole,exe,打包,类库,发布,注册 相关教程
- 如何发布我的数据库?
- 高手帮帮我
- 我最喜欢的一个按钮控件aspop,功能强大。可惜是老外编的,没有源码。那位仁兄有,可以给我吗?(重金购买)
- 很简单的问题,大家帮帮我啊!(也有助于大家提高对数据库的理解)
- 在win2000/xp下,怎样屏蔽win,ctrl+esc菜单快捷健,帮帮忙,谢谢了!!!?
- 关于FIND查找相同记录问题
- 如果以每天添加400条记录算,Access2000能不能胜任?给点建议!!
- 在VB中怎样自动获取系统的分辨率?
Form1.Data1.RecordSource ="select * from 表名称 where 姓名='"& namestring &"'"
(更详细地请看sql语句使用说明)
Form1.Data1.Recordset.edit
Form1.Data1.Recordset.Fields(0) = name1
Form1.Data1.Recordset.Fields(6) = department
Form1.Data1.Recordset.Fields(7) = class
Form1.Data1.Recordset.Fields(4) = num
Form1.Data1.Recordset.Fields(1) = sex
Form1.Data1.Recordset.Fields(3) = area
Form1.Data1.Recordset.Fields(5) = minzu
Form1.Data1.Recordset.Fields(8) = address
Form1.Data1.Recordset.Fields(9) = code
Form1.Data1.Recordset.Fields(2) = bir
Form1.Data1.Recordset.Update
Form1.Data1.Refresh
表中有一项数据是姓名为namestring的数据,并有其它字段(department,class等)
从相应的text中读取 要修改的内容到department,class等字符串变量,然后执行
Form1.Data1.Recordset.Fields(0) = name1
Form1.Data1.Recordset.Fields(6) = department
Form1.Data1.Recordset.Fields(7) = class
Form1.Data1.Recordset.Fields(4) = num
Form1.Data1.Recordset.Fields(1) = sex
Form1.Data1.Recordset.Fields(3) = area
Form1.Data1.Recordset.Fields(5) = minzu
Form1.Data1.Recordset.Fields(8) = address
Form1.Data1.Recordset.Fields(9) = code
Form1.Data1.Recordset.Fields(2) = bir
这些语句进行更新,在这前应该有edit,之后要有update和refresh