ADO Recordset.ppt

ASP-ADORecordset（记录集） 刘林东/Daniel lld@gdei.edu.cnRecordset Represents the entire set of records from a base table or the results of an executed command. At any time, the Recordset object refers to only a single record within the set as the current record. Recordset You use Recordset objects to manipulate data from a provider. When you use ADO, you manipulate data almost entirely using Recordset objects. All Recordset objects consist of records (rows) and fields (columns). Depending on the functionality supported by the provider, some Recordset methods or properties may not be available. Create a recordset object You can create as many Recordset objects as needed. Method-addnew AddNew:The method creates a new record for an updateable Recordset object. After you call this method, the new record will be the current record.? Syntax objRecordset.AddNew fieldlist,values SQl=“select * from user where sex=‘M’”rs.open sql,conn Method-addnew Example %rs.AddNew ProductName,Chang%or%varfields=Array(ProductName,Prize,Quantity)varvalues=Array(Chang,19,24-12 oz bottles)rs.AddNew varfields,varvalues% Method Cancel:The Cancel method cancels an execution of a method call. CancelBatch:The method cancels a batch update. The Recordset must be in batch update mode when calling this method. CancelUpdate:The method cancels changes made to a record of a Recordset object, or the Fields collection of a Record object, before calling the Update method. Method Close:The method is used to close a Connection object, a Record object, a Recordset object, or a Stream object to free system resources. Delete:The method is used to delete the current record or a group of records. After deleting a record, the deleted record remains current until you move to a different record. Note: To use this method assure that the Recordset object allows record deletion. Note: If this method fails, the provider will not stop the execution, but it will send a warning to the Errors Collectio