ADOdb. Properties and methods of the recordset

Source: Internet
Author: User

To keep track of the data more precisely, to create a cursor that includes data with the recordset component, the cursor is the data stored in memory:

rs = Server.CreateObject ("ADODB". RecordSet ")

Rs. Open (Sqlstr,conn,1,a)

Note: a=1 means reading data; a=3 means adding, altering, or deleting data.

The frequently used properties and methods in the Recordset component are:

Rs. The number of Fields.Count:RecordSet object fields.

RS (i). Name: The first field names, I is 0 to Rs. Fields.count-1

RS (i): Data for the first field, I is 0 to Rs. Fields.count-1

RS (field name): Specifies the data for the field.

Rs. Record.count: Total number of data records.

Rs. EOF: Whether the last record.

Rs. MoveFirst: Points to the first record.

Rs. MoveLast: Points to the last record.

Rs. MovePrev: Points to the previous record.

Rs. MoveNext: Points to the next record.

Rs. GetRows: Puts the data into the array.

Rs. Properties.Count:ADO the number of properties of the ResultSet or connection.

Rs. Properties (item). Name:ado the name of the ResultSet or connection.

Rs. The value of the Properties:ado resultset or connection.

Rs.close (): Closes the connection.

ADOdb. Properties and methods of the recordset

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.