ADOdb. Properties and methods of the recordset

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