我的工程中定义了users类模块,初始化
Public Sub Init()
Name = ""
Password = ""
End SubPublic Sub insert()
CONN
Dim strsql As String
strsql = "insert to users(username,password) values(username,userpassword) "
cnn.Execute (strsql)
cnn.Close
End Sub
以上是类模块的内容;
我的窗体上只有两个文本筐和一个按纽;实现添加;txtname,txtpassword
private sub cmd_add_click()
user.name=trim(txtname.text)
user.password=trim(txtpassword.txt)
users.insert
end sub数据库连接是: Dim cnn As New ADODB.Connection
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\exam.mdb;Persist Security Info=False"
cnn.Open
If cnn.State = adStateOpen Then
MsgBox "连接成功!"
Else: MsgBox "连接失败"
End If
End Function
添加时出错,说找不到对象“要求对象”
能告诉我吗;我急啊
Public Sub Init()
Name = ""
Password = ""
End SubPublic Sub insert()
CONN
Dim strsql As String
strsql = "insert to users(username,password) values(username,userpassword) "
cnn.Execute (strsql)
cnn.Close
End Sub
以上是类模块的内容;
我的窗体上只有两个文本筐和一个按纽;实现添加;txtname,txtpassword
private sub cmd_add_click()
user.name=trim(txtname.text)
user.password=trim(txtpassword.txt)
users.insert
end sub数据库连接是: Dim cnn As New ADODB.Connection
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\exam.mdb;Persist Security Info=False"
cnn.Open
If cnn.State = adStateOpen Then
MsgBox "连接成功!"
Else: MsgBox "连接失败"
End If
End Function
添加时出错,说找不到对象“要求对象”
能告诉我吗;我急啊
解决方案 »
- 如何修改VB小程序的复选框为选上(没有源码)
- 请给小妹说个别vb和matrixVB的画图问题好吗
- 如何更改主机名称
- 用什么工具制作VB按钮啊。。。
- 利用shell调用.exe的问题
- 如何实现控件浮动提示的显示//
- 求救:Dim con As ADODB.Connection 编译不过,怎么办???
- 请教:关于connetion、recorset属性的使用
- 为什么老是说“下标越界”?
- 请问:何处有msdn宇宙版可以下载?
- 请问在vb中,如何找到类似于A06,A4,A ,A1等类型的字符(内详)
- 我是一个菜鸟想做vb与access的连接,还不知道具体需要哪些操作。例如需要什么属性与什么语句。请各位指点。
private sub cmd_add_click() dim user as new users
user.name=trim(txtname.text)
user.password=trim(txtpassword.txt)
if user.ConnDB then
user.insert
user.DisConnDB
end if set user = nothing
end sub'类模块
public Name as string
public Password as string
Dim cnn as ADODB.ConnectionPublic Sub Init() Name = ""
Password = ""End SubPublic Sub insert()
Dim strsql As String
strsql = "insert to users(username,password) values(username,userpassword) "
cnn.Execute (strsql)
cnn.Closeend subpublic function ConnDB() set cnn = New ADODB.Connection
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\exam.mdb;Persist Security Info=False"
cnn.Open
If cnn.State = adStateOpen Then
ConnDB = true
MsgBox "连接成功!"
Else
ConnDB = false
MsgBox "连接失败"
End If
End Functionpublic function DisConnDB()
cnn.close
set cnn = nothing
end function
Name和Password是Users类的成员来的,你定义了没有啊?
user.password=trim(txtpassword.Text)就行了。
Dim StrSql As String
M_Cnn.CursorLocation = adUseClient
CreateMdbConn M_cnn,"C:\DEMO.MDB","sa","123"
StrSql = "select * FROM authors"
M_Rs.CursorLocation = adUseClient
M_Rs.Open StrSql, M_Cnn, adOpenKeyset, adLockBatchOptimistic
Set DataGrid1.DataSource = M_Rs
DataGrid1.Refresh
End Sub