Thursday, November 5, 2015

Data Access

11/5/2015

- VB supports various data access techniques, such as Data Access Object (DAO), Remote Data Object (RDO), and Active Data Object (ADO). It can access data from a number of sources, namely, Jet, ISAM, ODBC, and so on. Visual Basic can also access data from flat files.



Data Access Techniques:
Data access refers to software and activities related to storing, retrieving, or acting on data housed in a database or other repository. Following are the various techniques used in accessing the data.

Data Access Object (DAO)
DAO/ODBCDirect
Remote Data Objects (RDO)
Active Data Objects (ADO)

ADO object Model:







Stored Procedures:

A stored procedure sometimes called a sproc is a program or procedure, which is physically stored within a database. The exact implementation of a stored procedure varies from one database to the other.



Recordset:








No comments:

Post a Comment