sqlxml-managed-classes-sqlxmladapter-object.md

title	SqlXmlAdapter Object (SQLXML Managed Classes) | Microsoft Docs
ms.custom
ms.date	03/16/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
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	jhubbard

SQLXML Managed Classes - SqlXmlAdapter Object

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)