sqlxml-managed-classes-sqlxmladapter-object.md

---

title: "SqlXmlAdapter Object (SQLXML Managed Classes) | Microsoft Docs" ms.custom: "" ms.date: "03/16/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database" ms.service: "" ms.component: "sqlxml" ms.reviewer: "" ms.suite: "sql" ms.technology:

• "dbe-xml" ms.tgt_pltfrm: "" ms.topic: "reference" helpviewer_keywords:
• "void Update(DataSet ds) method"
• "SqlXmlAdapter object"
• "void Fill(DataSet ds) method"
• "SQLXML Managed Classes, SqlXmlAdapter object"
• "Managed Classes [SQLXML], SqlXmlAdapter object" ms.assetid: 0a16eddf-fc26-4d92-82d4-359b5fb905d5 caps.latest.revision: 22 author: "douglaslMS" ms.author: "douglasl" manager: "craigg" monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"

---

SQLXML Managed Classes - SqlXmlAdapter Object

[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md] This object provides methods that facilitate interaction with the dataset in the [!INCLUDEmsCoName] .NET Framework. For a working sample, see Accessing SQLXML Functionality in the .NET Environment.

The SqlXmlAdapter object supports these methods:

void Fill(DataSet ds)
Fills the dataset in the .NET Framework with the XML data retrieved from [!INCLUDEssNoVersion].

void Update(DataSet ds)
Applies updates to records in [!INCLUDEssNoVersion] from the data in the dataset.

The SqlXmlAdapter object supports these constructors:

public SqlXmlAdapter(SqlXmlCommand  cmd)   
  
public SqlXmlAdapter(  
                     string commandText,   
                     SqlXmlCommandType cmdType,   
                     string connectionString  
                      )   
  
public SqlXmlAdapter(  
                     Stream commandStream,   
                     SqlXmlCommandType cmdType,   
                     string connectionString  
                     )   

See Also

SqlXmlCommand Object (SQLXML Managed Classes)
SqlXmlParameter Object (SQLXML Managed Classes)