Page 272 - DCAP408_WEB_PROGRAMMING

Web Programming Mandeep Kaur, Lovely Professional University

Notes Unit 12: Recordset Object

CONTENTS
Objectives
Introduction

12.1 The Recordset Object
12.1.1 CursorType Property
12.2 Filter Property

12.2.1 Settings and Return Values
12.3 Fields Collection
12.3.1 Sorting of Recordset
12.4 Summary
12.5 Keywords

12.6 Review Questions
12.7 Further Readings

Objectives

After studying this unit, you will be able to:

 Define record set object
 Describe filter property
 Explain fields collection

Introduction

Enhancing Information Retrieval (Using the fields Collection); Understanding the cursor type
and cursor location properties; sorting recordsets; filtering recordsets (filtering recordsets bases
on user input).

The Recordset object represents a set of records returned from a database query. It is used to
examine and manipulate data within a database. Combined with the cursor service, it enables us
to move through the records, find particular records that fit certain criteria, sort records in a
particular order, and update records.
The Recordset object is probably the most commonly used ADO object. It has a rather more
complex interface than the other objects in the ADO object model which exposes many more
methods and properties. Once we have created and populated a recordset, we can then use other
parts of the interface to work with the contents of the recordset.
A Recordset object allows us to access individual records( the rows of the database) and fields
(the columns). The set of fields associated with a recordset (and with each individual record) is
accessible through the Fields collection and Field object.
Like the Command and Record objects, a Recordset can either exist on its own or be attached to
a Connection. The latter is a preferred option when we are creating several recordsets within a

266 LOVELY PROFESSIONAL UNIVERSITY