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;
using System.Data;
using System.Xml;
using System.Data.SqlClient;

public class Sample
{
  public static void Main()
  {
     DataSet dsNorthwind = new 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 = new 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 = new SqlDataAdapter(sCommand, nwconnect);

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

     //Load the document with the DataSet.
     XmlDataDocument doc = new 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: