• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Connection Database Through ADO...

Connection Database Through ADO...

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




Rate Connection Database Through ADO...

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

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