sqlxml-4-0-net-framework-support-using-diffgrams-to-modify-data.md

title	Using DiffGrams to Modify Data in SQLXML 4.0
ms.custom
ms.date	03/17/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.reviewer
ms.technology	xml
ms.topic	reference
helpviewer_keywords	data deletions [SQLXML] updating data [SQLXML] DiffGrams [SQLXML] modifying data [SQLXML] .NET Framework [SQLXML], DiffGrams XML [SQLXML] database modifications [SQLXML] data updates [SQLXML] data modifications [SQLXML] record insertion [SQLXML] SQLXML, DiffGrams deleting data record updates [SQLXML] record deletions [SQLXML]
ms.assetid	48b8a8f9-f3af-404f-8c84-f4c3703364d9
author	MightyPen
ms.author	genemi
monikerRange	=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

SQLXML 4.0 .NET Framework Support - Using DiffGrams to Modify Data

[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md] The DiffGram format is introduced in the DataSet component of the [!INCLUDEmsCoName] .NET Framework. Within the .NET Framework, you can create DiffGrams and use them to modify data in tables in a Microsoft [!INCLUDEssNoVersion] database.

Note

This section provides a brief introduction to DiffGrams and examples of how to use them. It is assumed that you are familiar with DiffGrams in the .NET Framework. In this documentation, the primary focus is on DiffGram issues that are specific to SQLXML.

In This Section

Introduction to DiffGrams in SQLXML 4.0
Provides basic information about Diffgrams.

DiffGram Examples (SQLXML 4.0)
Provides examples of using Diffgrams.

Executing a DiffGram by Using ADO (SQLXML 4.0)
Provides an example of executing a Diffgram with ActiveX Data Objects (ADO).

Executing a DiffGram by Using SQLXML Managed Classes
Provides an example of executing a Diffgram with SQLXML Managed Classes.