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

---

title: "Using DiffGrams to Modify Data in SQLXML 4.0 | Microsoft Docs" ms.custom: "" ms.date: "03/17/2017" ms.prod: sql ms.prod_service: "database-engine, sql-database" ms.component: "sqlxml" ms.reviewer: "" ms.suite: "sql" ms.technology: xml ms.tgt_pltfrm: "" 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 caps.latest.revision: 22 author: "douglaslMS" ms.author: "douglasl" manager: craigg monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017"

---

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.