ADO » DataControl » SubmitChanges



This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Applications that use RDS should migrate to WCF Data Service.

The SubmitChanges method is deprecated in ADO.

Sends all of the pending changes in the locally cached Recordset object down to the underlying data source.

The SubmitChanges method is called to submit any pending changes to the data source of the Recordset.

The Recordset must be updateable. Also, the Connect, Server, and SQL properties must first be set. If the URL property is set, the pending changes will be sent to the specified location. If the pending changes have been filtered, only those pending changes that survived being filtered will be sent to the data source for updating.

Note that only the changes are submitted, not the entire Recordset. Every one of the changes must be successfully completed or the entire update attempt fails and none of the changes will be committed to the data source.

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 CancelUpdate method.


Sub SubmitChange_OnClick
End Sub

Sub CancelUpdate_OnClick
End Sub

See Also: