R
ronaldlee
HI,
how to do a RecordSet in OleDbConnection???
my original code is using ADODB.RecordSet
But how can i do the RecordSet in OleDbConnection?
my original code
Function openDB() As Object
objConn = New ADODB.Connection
objConn.Open(dbDNS) '("dbfile")
objRS = New ADODB.Recordset
End Function
Function closeDB() As Object
' If the RecordSet has a state of 1 (open) close it
If objRS.state = 1 Then
objRS.Close()
End If
objConn.Close()
objConn = Nothing
End Function
*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*
how to do a RecordSet in OleDbConnection???
my original code is using ADODB.RecordSet
But how can i do the RecordSet in OleDbConnection?
my original code
Function openDB() As Object
objConn = New ADODB.Connection
objConn.Open(dbDNS) '("dbfile")
objRS = New ADODB.Recordset
End Function
Function closeDB() As Object
' If the RecordSet has a state of 1 (open) close it
If objRS.state = 1 Then
objRS.Close()
End If
objConn.Close()
objConn = Nothing
End Function
*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*