Quick References
      ADO
      ASP
      CSS2
      HTML
      JavaScript
      Jet SQL
      VBScript
      WML
      WMLScript
      WSH
      XHTML
      XML DOM
      XSLT

Features
      Knowledge Base
      Tutorials

Partners
     ZVON.ORG
     XML
     Planet Source Code
     VisualBuilder
     Web Design
     Your HTML Source
     XML/XSLT Forums
     ASPAlliance
     Scripts
     
     Programmers Heaven
     Tek-Tips Forums
     Developer Fusion
     Code Project











METHOD:  DataControl::CancelUpdate
datacontrolobject.CancelUpdate

The CancelUpdate method is used to cancel and discard all pending changes made to the source recordset since the last Refresh or SubmitChange method call. This method resets the local cache containing the pending changes to empty.

Since ADO stores the data separate from the pending changes, you simply revert back to the previous set of data as it existed in the Recordset after the last update or call to Refresh.

You can use buttons on a Web page to navigate and manipulate a displayed recordset. For example, when the appropriate button is clicked, you can call a subroutine containing either this method or the SubmitChanges method:

Code (VBScript):
Sub SubmitChange_OnClick
   objDataControl.SubmitChanges
   objDataControl.Refresh
End Sub

Sub CancelUpdate_OnClick
   objDataControl.CancelUpdate
   objDataControl.Refresh
End Sub

  


Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information