Shulou(Shulou.com)06/02 Report--

This article mainly explains "what are the attributes of ADO". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "what are the ADO attributes"!

Such as: set the location of the current record is on which page AbsolutePosition attribute: the current position of the indicator in the RecordSet, display the total number of Recordset object records.

The paging display of the ADO attribute is actually an operation on the record of the Recordset. So we must first understand the properties and methods of the Reordset object:

BOF attribute: the current metric refers to the * * pen of RecordSet.

EOF attribute: the current metric refers to the * of RecordSet.

Move method: move the metric to a record in RecordSet.

ADO attribute: sets the page on which the location of the current record is located AbsolutePosition attribute: the current position of the metric in the RecordSet.

PageCount property: data that shows how many "pages" the Recordset object contains.

PageSize property: displays the number of records displayed on each page of the Recordset object.

RecordCount property: displays the total number of Recordset object records.

Let's take a closer look at these important properties and methods.

1. BOF and ADO attributes

Usually we write code in the program to verify the BOF and EOF attributes, so as to know the location of the RecordSet pointed to by the current indicator. Using the BOF and EOF properties, we can know whether a Recordset object contains records or whether mobile record rows have gone beyond the scope of the Recordset object.

2. Move method

You can use the Move method to move metrics to a record in RecordSet. The syntax is as follows:

Rs.Move NumRecords,Start

Here "rs" is an object variable, indicating a Recordset object that you want to move when the current record location; "NumRecords" is a positive and negative expression that sets the number of movements of the current record location; and "start" is an optional item that specifies the label for the beginning of the record.

All ADO properties support the Move method, and if the NumRecords parameter is greater than zero, the current record position moves toward the end; if it is less than zero, the current record position moves toward the beginning; if an empty Recordset object calls the Move method, an error will be generated.

At this point, I believe you have a deeper understanding of "what are the ADO attributes?" you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.