我在模块module1里加“Public cn As Connection”了
为什么还要在每个控件里都重复写上
“Set cn = New ADODB.Connection
cn.ConnectionString = "Provider=OraOLEDB.Oracle.1;Passwor=后面省略
cn.Open”
否则,一执行“rs1.open"select......",cn, adOpenDynamic, adLockOptimistic, adCmdText”
就报连接未打开,好麻烦啊!请高手指点
为什么还要在每个控件里都重复写上
“Set cn = New ADODB.Connection
cn.ConnectionString = "Provider=OraOLEDB.Oracle.1;Passwor=后面省略
cn.Open”
否则,一执行“rs1.open"select......",cn, adOpenDynamic, adLockOptimistic, adCmdText”
就报连接未打开,好麻烦啊!请高手指点
'类模块
Dim cn As ADODB.Connection
Public Function Opencn(Optional ByVal strcn As String) As ADODB.Connection
'如果连接字符串为空,使用默认字符串连接数据库
If strcn = "" Then
strcn = "Provider=OraOLEDB.Oracle.1;Passwor=后面省略"
End If
Dim cn As New ADODB.Connection
cn.ConnectionString = strcn
cn.Open
Set Opencn = cn
End Function'Form 声明部分
Option Explicit
Dim cn As New ADODB.Connection'在你的程序中的调用
Set cn = Opencn
Public rs1 As New ADODB.RecordSet