Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

XmlDataDocument::GetRowFromElement Method

Retrieves the DataRow associated with the specified XmlElement.

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

public:
DataRow^ GetRowFromElement(
	XmlElement^ e
)

Parameters

e
Type: System.Xml::XmlElement

The XmlElement whose associated DataRow you want to retrieve.

Return Value

Type: System.Data::DataRow
The DataRow containing a representation of the XmlElement; nullptr if there is no DataRow associated with the XmlElement.

The following example modifies the price of the first book.

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

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

int main()
{
   // Create an XmlDataDocument.
   XmlDataDocument^ doc = gcnew XmlDataDocument;

   // Load the schema file.
   doc->DataSet->ReadXmlSchema( "store.xsd" );

   // Load the XML data.
   doc->Load( "2books.xml" );

   //Change the price on the first book.
   XmlElement^ root = doc->DocumentElement;
   DataRow^ row = doc->GetRowFromElement( safe_cast<XmlElement^>(root->FirstChild) );
   row["price"] = "12.95";
   Console::WriteLine( "Display the modified XML data..." );
   Console::WriteLine( doc->DocumentElement->OuterXml );
}

The example uses the following input files:

2books.xml


<!--sample XML fragment-->
<bookstore>
  <book genre='novel' ISBN='10-861003-324'>
    <title>The Handmaid's Tale</title>
    <price>19.95</price>
  </book>
  <book genre='novel' ISBN='1-861001-57-5'>
    <title>Pride And Prejudice</title>
    <price>24.95</price>
  </book>
</bookstore>

store.xsd


<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">

 <xsd:element name="bookstore" type="bookstoreType"/>

 <xsd:complexType name="bookstoreType">
  <xsd:sequence maxOccurs="unbounded">
   <xsd:element name="book"  type="bookType"/>
  </xsd:sequence>
 </xsd:complexType>

 <xsd:complexType name="bookType">
  <xsd:sequence>
   <xsd:element name="title" type="xsd:string"/>
   <xsd:element name="author" type="authorName"/>
   <xsd:element name="price"  type="xsd:decimal"/>
  </xsd:sequence>
  <xsd:attribute name="genre" type="xsd:string"/>
 </xsd:complexType>

 <xsd:complexType name="authorName">
  <xsd:sequence>
   <xsd:element name="first-name"  type="xsd:string"/>
   <xsd:element name="last-name" type="xsd:string"/>
  </xsd:sequence>
 </xsd:complexType>

</xsd:schema>

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1
Show:
© 2015 Microsoft