窗体载入的时候连接数据库,连接成功了,可是,为什么我不能用在它的函数里面呢Private Sub Form_Load()
Set cn = New ADODB.Connection
connectstring = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\bui.mdb;Persist Security Info=False;Jet OLEDB:database Password=1234"
cn.Open connectstring
End Sub'' 这里我已经连接上库了
'' 下面的事件如果我这样写,就出现错误提示,不正确。
Private Sub Command1_Click() Set rst = New ADODB.Recordset
varuser = username.Text
varpass = password.Text
''sqllog = "select passwords from administra where admins='" & varuser & "'"
sqllog = "select passwords from administra where admins='" & varuser & "'"
MsgBox sqllog
rst.Open sqllog, cn, 1, 1 ''adOpenKeyset, adLockOptimistic
If Not rst.EOF Then
therspass = rst("passwords")
MsgBox therspass
End If
MsgBox username.Text
End Sub''这样写就没有问题
Private Sub Command1_Click()
Set cn = New ADODB.Connection
connectstring = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\bui.mdb;Persist Security Info=False;Jet OLEDB:database Password=1234"
cn.Open connectstring
Set rst = New ADODB.Recordset
varuser = username.Text
varpass = password.Text
''sqllog = "select passwords from administra where admins='" & varuser & "'"
sqllog = "select passwords from administra where admins='" & varuser & "'"
MsgBox sqllog
rst.Open sqllog, cn, 1, 1 ''adOpenKeyset, adLockOptimistic
If Not rst.EOF Then
therspass = rst("passwords")
MsgBox therspass
End If
MsgBox username.Text
End Sub
为什么我非要在连接一次数据库呢,怎么才能在一个应用程序里面我只连接一次数据库阿
Set cn = New ADODB.Connection
connectstring = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\bui.mdb;Persist Security Info=False;Jet OLEDB:database Password=1234"
cn.Open connectstring
End Sub'' 这里我已经连接上库了
'' 下面的事件如果我这样写,就出现错误提示,不正确。
Private Sub Command1_Click() Set rst = New ADODB.Recordset
varuser = username.Text
varpass = password.Text
''sqllog = "select passwords from administra where admins='" & varuser & "'"
sqllog = "select passwords from administra where admins='" & varuser & "'"
MsgBox sqllog
rst.Open sqllog, cn, 1, 1 ''adOpenKeyset, adLockOptimistic
If Not rst.EOF Then
therspass = rst("passwords")
MsgBox therspass
End If
MsgBox username.Text
End Sub''这样写就没有问题
Private Sub Command1_Click()
Set cn = New ADODB.Connection
connectstring = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\bui.mdb;Persist Security Info=False;Jet OLEDB:database Password=1234"
cn.Open connectstring
Set rst = New ADODB.Recordset
varuser = username.Text
varpass = password.Text
''sqllog = "select passwords from administra where admins='" & varuser & "'"
sqllog = "select passwords from administra where admins='" & varuser & "'"
MsgBox sqllog
rst.Open sqllog, cn, 1, 1 ''adOpenKeyset, adLockOptimistic
If Not rst.EOF Then
therspass = rst("passwords")
MsgBox therspass
End If
MsgBox username.Text
End Sub
为什么我非要在连接一次数据库呢,怎么才能在一个应用程序里面我只连接一次数据库阿
解决方案 »
- 刚装上水晶报表,发现必须要设置数据源,难道数据源不是用程序中的吗?感觉水晶是个独立的东西,如何与我的程序结合起来呢?
- 请人做个项目
- VB dll问题请教
- 求教!看来不得不问了,高手看过来,局域网中连接ACCESS的问题。
- 在线等待。新手上路:VB中如何代码实现定时开/关机?哪位回答的最全20分就给那位。谢谢!!
- 问一个关于SetWindowPos的问题
- 求tetrisbox控件
- 1、有关MSHFlexGrid1的问题 2、怎样判断窗体已打开
- 比较急的问题,粗学者的问题~
- 如何通过ADO连接DB2数据库
- 哪个打包工具能把安装程序制作成只有一个文件的样子?
- Persist Security Info=false/or 代表什么意思,在线等!谢谢
Public mycon As New ADODB.Connection
Private Sub Form_Load()
connectstring = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\bui.mdb;Persist Security Info=False;Jet OLEDB:database Password=1234"
cn.Open connectstring
End Sub
Private Sub Command1_Click() Set rst = New ADODB.Recordset
varuser = username.Text
varpass = password.Text
''sqllog = "select passwords from administra where admins='" & varuser & "'"
sqllog = "select passwords from administra where admins='" & varuser & "'"
MsgBox sqllog
rst.Open sqllog, cn, 1, 1 ''adOpenKeyset, adLockOptimistic
If Not rst.EOF Then
therspass = rst("passwords")
MsgBox therspass
End If
MsgBox username.Text
End Sub
public rs as adodb.recordsetprivate sub main()
'在这里写连接数据库的代码
set cn = new adodb.connection
set rs = new adodb.recrodset
.......
....
end sub然后在工程属性里设置从 Sub Main 启动