dbclass.cls

来自「Make a graph from database record and ei」· CLS 代码 · 共 40 行

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
  Persistable = 0  'NotPersistable
  DataBindingBehavior = 0  'vbNone
  DataSourceBehavior  = 0  'vbNone
  MTSTransactionMode  = 0  'NotAnMTSObject
END
Attribute VB_Name = "dbclass"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = True
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False
Dim db As ADODB.Connection
Private Sub Class_Initialize()
'  IsError = False
  Set db = New ADODB.Connection
  On Error GoTo dbctlerror
  Set strdbname = Nothing
  
db.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=" & App.Path & "\cdata.mdb;"

db.CursorLocation = adUseClient
  Exit Sub
dbctlerror:
  MsgBox Err.Number & Err.Description & " dbclass error !"
'  IsError = True
End Sub

Private Sub Class_Terminate()
  db.Close
  Set db = Nothing
End Sub

Public Property Get dbname3() As Connection
  Set dbname3 = db
End Property