XmlDataDocument.GetRowFromElement(XmlElement) Method

Reference

Definition

Namespace:: System.Xml

Assembly:: System.Data.Common.dll

Assembly:: System.Data.dll

Source:: XmlDataDocument.cs

Source:: XmlDataDocument.cs

Source:: XmlDataDocument.cs

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Retrieves the DataRow associated with the specified XmlElement.

public:
 System::Data::DataRow ^ GetRowFromElement(System::Xml::XmlElement ^ e);

public System.Data.DataRow? GetRowFromElement(System.Xml.XmlElement? e);

public System.Data.DataRow GetRowFromElement(System.Xml.XmlElement e);

member this.GetRowFromElement : System.Xml.XmlElement -> System.Data.DataRow

Public Function GetRowFromElement (e As XmlElement) As DataRow

Parameters

e: XmlElement

The XmlElement whose associated DataRow you want to retrieve.

Returns

DataRow

The DataRow containing a representation of the XmlElement; null if there is no DataRow associated with the XmlElement.

Examples

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 );
}

using System;
using System.Data;
using System.Xml;
public class Sample {
    public static void Main() {
        // Create an XmlDataDocument.
        XmlDataDocument doc = new 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((XmlElement)root.FirstChild);
        row["price"] = "12.95";

        Console.WriteLine("Display the modified XML data...");
        Console.WriteLine(doc.DocumentElement.OuterXml);
    }
} // End class

Imports System.Data
Imports System.Xml

public class Sample

  public shared sub Main()

      'Create an XmlDataDocument.
      Dim doc as XmlDataDocument = new XmlDataDocument()

      'Load the schema.
      doc.DataSet.ReadXmlSchema("store.xsd") 
 
      'Load the XML data.
      doc.Load("2books.xml")
        
      'Change the price on the first book.
      Dim book as XmlElement 
      book = CType(doc.DocumentElement.FirstChild, XmlElement)
      Dim row as DataRow 
      row = doc.GetRowFromElement(book)
      row.Item("price") = "12.95"
        
     Console.WriteLine("Display the modified XML data...")
     Console.WriteLine(doc.DocumentElement.OuterXml)

  end sub
end class

The example uses the following input files:

2books.xml

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

XML


<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>

Applies to

Produkt	Versioner
.NET	Core 3.0, Core 3.1, 5, 6, 7, 8, 9, 10
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1

Dela via