请问在公共模块中设置好的连接为什么在其他的form要模块中使用不可以啊?我用的是ado代码如下:
public function()
dim cn as adodb.connection
cn.connecction="provider=oledb;servere=dataserver;database=db;uid=sa;pwd=;
cn.open
end function
form中:
dim rs as new recordset
rs.open "select * from tablename",cn
public function()
dim cn as adodb.connection
cn.connecction="provider=oledb;servere=dataserver;database=db;uid=sa;pwd=;
cn.open
end function
form中:
dim rs as new recordset
rs.open "select * from tablename",cn
不过你要把dim cn as adodb.connection
改为public cn as adodb.connection
rs.open "select * from tablename",cn
放到function外
Public conn As New ADODB.Connection
Public rs As New ADODB.Recordset
connstr = "Providerprovider=oledb;servere=dataserver;database=db;uid=sa;pwd=;"
conn.Open connstrform
conn.Open connstr
Sql = "select * from tablename"
rs.Open Sql, conn, adOpenKeyset, adLockPessimistic
rs.Open Sql, conn, adOpenKeyset, adLockPessimistic
就可以了
不用
conn.Open connstr
public cn as new adodb.connection '记住写上 new 关键字。否则在form 得 set
public function()
cn.connecction="provider=oledb;servere=dataserver;database=db;uid=sa;pwd=;
cn.open
end function
form中:
dim rs as new recordset
rs.open "select * from tablename",cn这样就可以了