Recordset

A RecordSet consists of a collection of Record objects. ; Stream : A stream, mainly used in a RecordSet object, is a means of reading and writing a stream of bytes.

In a Recordset object, each of the Field objects that make up the Fields collection corresponds to a column in that Record set object.

It is mostly used to save a recordset in an XML format, to send commands to an OLE DB provider as an alternative to the CommandText object and to contain the contents of a binary or text file.

The Collection can be used in either a Recordset object or in a Record object.

The RecordSet has numerous methods and properties for examining the data that exists within it.

The RecordSet object contains a Fields collection and a Properties collection.

The RecordSet object's Field object corresponds to a column in the database table that it references.