Methods for Recordset object recordsets

Rs.movenext moves the record pointer down one row from the current position
Rs.moveprevious move the record pointer up one row from the current position
Rs.movefirst move the record pointer to the first row of the datasheet
Rs.movelast move the record pointer to the last row of the datasheet
Rs.absoluteposition=n move the record pointer to the nth row of the datasheet
Rs.absolutepage=n move the record pointer to the first row of page N
Rs.pagesize=n set every page to N records
Rs.pagecount returns the total number of pages based on pagesize settings
Rs.recordcount returns the total number of records
RS.BOF returns whether the record pointer is over the first end of the datasheet, True indicates Yes, FALSE is no
Rs.eof returns whether the record pointer is over the end of the datasheet, True indicates Yes, FALSE is no
Rs.delete deletes the current record, but the record pointer does not move down
Rs.addnew add records to the end of the datasheet
Rs.update Update datasheet Record
--------------------------------------------------------------
Recordset Object Methods
Open method
Recordset. Open source,activeconnection,cursortype,locktype,options
Source
The Recordset object can connect to the command object through the Source property. The source parameter can be a command object name, a section of SQL command, a specified data table name, or a stored Procedure. If this argument is omitted, the system takes the source property of the Recordset object.
ActiveConnection
The Recordset object can connect connection objects by ActiveConnection properties. The ActiveConnection can be a connection object or a string parameter containing the database connection information (ConnectionString).
CursorType
The CursorType parameter of the Recordset object Open method indicates what cursor type will start the data, including adOpenForwardOnly, adOpenKeyset, adOpenDynamic, and adOpenStatic. It is described as follows:
--------------------------------------------------------------
Constant??????????????????????????????? Constant value????????????? ? description
--------------------------------------------------------------
adOpenForwardOnly???????? 0?????????????????????? The default value, starting a cursor that can only be moved forward (Forward only).
adOpenKeyset????????????? ??? ? 1?????????????????????? Launches a keyset type of cursor.
adOpenDynamic??????????????? 2?????????????????????? Launches a dynamic-type cursor.
adOpenStatic??????????????????? ? 3????????????????????? Launches a static type of cursor.
--------------------------------------------------------------