--- title: "SubmitChanges Method Example (VBScript) | Microsoft Docs" ms.prod: sql ms.technology: connectivity ms.custom: "" ms.date: "01/19/2017" ms.reviewer: "" ms.topic: conceptual dev_langs: - "VB" helpviewer_keywords: - "SubmitChanges method [ADO], VBScript example" ms.assetid: 619bc7fd-ad0a-44ea-9678-ad40a662c258 author: MightyPen ms.author: genemi --- # SubmitChanges Method Example (VBScript) > [!IMPORTANT] > Beginning with Windows 8 and Windows Server 2012, RDS server components are no longer included in the Windows operating system (see Windows 8 and [Windows Server 2012 Compatibility Cookbook](https://www.microsoft.com/download/details.aspx?id=27416) for more detail). RDS client components 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](https://go.microsoft.com/fwlink/?LinkId=199565). The following code fragment shows how to use the [SubmitChanges](../../../ado/reference/rds-api/submitchanges-method-rds.md) method with an [RDS.DataControl](../../../ado/reference/rds-api/datacontrol-object-rds.md) object. To test this example, cut and paste this code into a normal ASP document and name it **SubmitChangesCtrlVBS.asp**. ASP script will identify your server. ``` <%@Language=VBScript%> <%'Option Explicit%> <% 'use the following META tag instead of adovbs.inc%>

Remote Data Service

SubmitChanges and CancelUpdate Methods

<% ' to integrate/test this code replace the Server property value and ' the Data Source value in the Connect property with identical values%>
ID FName LName Title Hire Date Birth Date Extension Home Phone


Alter a current entry on the grid. Move off that Row.
Submit the Changes to your DBMS or cancel the updates.

``` ## See Also [DataControl Object (RDS)](../../../ado/reference/rds-api/datacontrol-object-rds.md) [SubmitChanges Method (RDS)](../../../ado/reference/rds-api/submitchanges-method-rds.md)