先引用Active Data object 2.5
Dim db As ADODB.Connection
'连接数据库
Set db = New ADODB.Connection
db.CursorLocation = adUseClient
db.Open strProvider
Set xBWStkTran = New Recordset
xBWStkTran.Open "select C.* from TB",db, adOpenStatic, dLockOptimistic
If xBWStkTran.RecordCount <= 0 Then xBWStkTran.Close
Set xBWStkTran = Nothing
db.Close
Set db = Nothing
End If
Dim db As ADODB.Connection
'连接数据库
Set db = New ADODB.Connection
db.CursorLocation = adUseClient
db.Open strProvider
Set xBWStkTran = New Recordset
xBWStkTran.Open "select C.* from TB",db, adOpenStatic, dLockOptimistic
If xBWStkTran.RecordCount <= 0 Then xBWStkTran.Close
Set xBWStkTran = Nothing
db.Close
Set db = Nothing
End If
没MSDN吗?买一套吧.
dim db = new ADODB.Connection
在没有加入ADODB的控件时是不能出来这段代码的
我只是想知道要不要在窗体上加入ADODB这个控件,谢谢