by Siva (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Thu 21st September 2000
Date Added: Mon 8th February 2021
Rating: (1 Votes)
Connection Database Through ADO...
API Declarations
'Created Date : 21/09/2000
'Go to Project Menu and click Reference and add ActiveX Data Objects..
Dim adoConn As New ADODB.Connection
Dim adoComm As New ADODB.Command
Dim adoRes As New ADODB.Recordset
adoConn.Open "......." 'Insert Dsn
Set adoComm = adoConn
adoComm.CommandText = "Select * from ......."
adoRes.CursorLocation = adUseClient
adoRes.Open adoComm, , adOpenStatic, adLockBatchOptimistic
'To update New Records..
adoRes.Addnew
.
.
.
adores.UpdateBatch
End Sub