sqlxml-managed-classes-sqlxmladapter-object.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords	monikerRange
SqlXmlAdapter Object (SQLXML)	Learn about the SqlXmlAdapter object that provides methods that facilitate interaction with the dataset in the .NET Framework.	MikeRayMSFT	mikeray	03/16/2017	sql	xml	reference	void Update(DataSet ds) method SqlXmlAdapter object void Fill(DataSet ds) method SQLXML Managed Classes, SqlXmlAdapter object Managed Classes [SQLXML], SqlXmlAdapter object	=azuresqldb-current||>=sql-server-2016||>=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)