XmlDataDocument::GetElementFromRow Method (DataRow^)

 

Retrieves the XmlElement associated with the specified DataRow.

Namespace:   System.Xml
Assembly:  System.Data (in System.Data.dll)

public:
XmlElement^ GetElementFromRow(
	DataRow^ r
)

Parameters

r
Type: System.Data::DataRow^

The DataRow whose associated XmlElement you want to retrieve.

Return Value

Type: System.Xml::XmlElement^

The XmlElement containing a representation of the specified DataRow.

The following example loads a DataSet into an XmlDataDocument and then creates an XmlElement representing the first customer record.

The example uses the SQL Server 2000 Northwind database.

#using <System.Xml.dll>
#using <System.Transactions.dll>
#using <System.EnterpriseServices.dll>
#using <System.dll>
#using <System.Data.dll>

using namespace System;
using namespace System::Data;
using namespace System::Xml;
using namespace System::Data::SqlClient;

int main()
{
   DataSet^ dsNorthwind = gcnew DataSet;

   //Create the connection string           
   String^ sConnect;
   sConnect = "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind";

   //Create a connection object to connect to the northwind db.
   SqlConnection^ nwconnect = gcnew SqlConnection( sConnect );

   //Create a command string to select all the customers in the WA region.
   String^ sCommand = "Select * from Customers where Region='WA'";

   //Create an adapter to load the DataSet.
   SqlDataAdapter^ myDataAdapter = gcnew SqlDataAdapter( sCommand,nwconnect );

   //Fill the DataSet with the selected records.
   myDataAdapter->Fill( dsNorthwind, "Customers" );

   //Load the document with the DataSet.
   XmlDataDocument^ doc = gcnew XmlDataDocument( dsNorthwind );

   //Create an element representing the first customer record.
   DataRow^ row = doc->DataSet->Tables[ 0 ]->Rows[ 0 ];
   XmlElement^ elem = doc->GetElementFromRow( row );
   Console::WriteLine( elem->OuterXml );
}

.NET Framework
Available since 1.1
Return to top
Show: