Question

Illustrate with an ASP program to access a database through ActiveX Data objects.​

Answer 1

Answer:

The Data Adapter

OleDb.OleDbDataAdapter. ...

da = New OleDb.OleDbDataAdapter(sql, con ) ...

SELECT * FROM Table_Name. ...

Select * from Table_Name. ...

"SELECT all the records FROM the table called Table_Name" ...

SELECT tblContacts.FirstName, tblContacts.Surname FROM tblContacts. ...

sql = "SELECT * FROM tblContacts" ...

da.Fill(ds, "AddressBook