Dim Cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Cnn.Open "Provider=Microsoft.Jet.OLEDB.3.51; Data Source=" & App.Path & "\db1.mdb;"
With rst
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open "select * from 表名", Cnn1, , , adCmdText
End With
rst.addnew
rst.fileds("name").values=text1.text
......
rst.update
Dim rst As New ADODB.Recordset
Cnn.Open "Provider=Microsoft.Jet.OLEDB.3.51; Data Source=" & App.Path & "\db1.mdb;"
With rst
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open "select * from 表名", Cnn1, , , adCmdText
End With
rst.addnew
rst.fileds("name").values=text1.text
......
rst.update
解决方案 »
- 马赛克问题!!!急啊!!!!高手指点下我应该找什么资料
- 求助怎样在窗体上横向输出数字。
- "Validate and CausesValidation" I LOVE YOU!
- 关于数据库图片显示问题!急急急急急急急急急急急
- 我有一个软件是VB编的,如何控制软件不让它到期
- 如何将系统里的汉字转换成纯二进制文件,一旦解决立即结贴
- 如何将FoxPro导入sql server 2000中,高分求教!
- Crystal Reports 9.0 的頁腳的問題?
- 请问采用VB程序读写Excel怎么解决如下问题?
- 关于用VB做的安装程序的UnInstall程序
- 请问各位大仙!如何利用ADO返回SQL Server的结果?急!急!急!
- 请教图片预览的实现
Dim rs As New ADODB.Recordset
Cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & App.Path & "\db.mdb;"
With rs
.LockType = adLockOptimistic
.Open "select name , sex from 表名", Cnn
End With
rs.addnew
rs.fields("name")=textname.text
rs.fields("sex")=textsex.text
rs.update
可以的
程序:
Public Function DBConnect() As Boolean
DBConnect = False
On Error GoTo ErrHandler
With g_Conn
.ConnectionString = "你的连接字符串"
.CommandTimeout=15 .CursorLocation=adUseClient .IsolationLevel=adXactChaos .Mode=adModeReadWrite .Open
End With
DBConnect = True
Exit Function
ErrHandler:
MsgBox "打开数据库错误",vbOKOnly, "错误"
End Function再在你的FROM里面
dim sname as string
sname=txtname.text
rs.Open "select * from 你的表 where name='" & sname & "'", g_Conn, adOpenKeyset, adLockOptimistic
If Not rs.EOF Then
rs.Close
MsgBox "关键字重复",vbOKOnly, "错误"
Exit Sub
End If
rs.AddNew
rs.Fields("name") = sname
rs.Fields("sex") = txtsex.Text
rs.Update
rs.Close
这样就可以了
rs.open str,conn