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