Page 250 - Open Soource Technologies 304.indd

Event Driven Programming Anil Sharma, Lovely Professional University

Unit 11: Data Base Access

CONTENTS

Objectives
Introduction
11.1 ADO Data Model
11.2 Data Access Objects (DAO)
11.3 The Remote Data Control
11.3.1 Opening a Database with an ADO Data Control
11.3.2 The ADO Data-Bound Controls
11.4 Data Base Access Using the ADO Data Control
11.4.1 Setting Up the ADO Data Control
11.4.2 Creating an ADO Data Control
11.5 ADO and ADOCE
11.6 Summary
11.7 Keywords
11.8 Self Assessment Questions
11.9 Review Questions
11.10 Further Readings

Objectives

After studying this unit, you will be able to:
• Discuss ADO data model
• Explain Data access object (DAO)
• Discuss the remote data control
• Explain data base access using the ADO data control
• Explain ADO and ADOCE
Introduction

ADO provides a new and powerful means of accessing data stored in databases. As a single, high-
level technology for accessing all types of databases, ADO is simpler and more efficient to use
than the two older data access technologies, DAO (Data Access Objects) and RDO (Remote Data
Objects). ADO combines the functionality of DAO and RDO into one interface and provides even
more features. Rather than having to choose DAO or RDO depending on the type of database
you need to access, you can use ADO to access any type of database or file. For example, while
DAO can connect to Microsoft Access .MDB databases, ADO can access HTML, plain text, Internet,
spreadsheet, and e-mail files, as well as .MDB and other types of databases.

244 LOVELY PROFESSIONAL UNIVERSITY