sqlxml-managed-classes-sqlxmladapter-object.md

title	SqlXmlAdapter Object (SQLXML)
description	Learn about the SqlXmlAdapter object that provides methods that facilitate interaction with the dataset in the .NET Framework.
ms.date	03/16/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.reviewer
ms.technology	xml
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
author	MightyPen
ms.author	genemi
ms.custom	seo-lt-2019
monikerRange	=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

SQLXML Managed Classes - SqlXmlAdapter Object

[!INCLUDE SQL Server Azure SQL Database 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)