XmlDataDocument::DataSet Property
.NET Framework (current version)
Gets a DataSet that provides a relational representation of the data in the XmlDataDocument.
Assembly: System.Data (in System.Data.dll)
Property Value
Type: System.Data::DataSet^A DataSet that can be used to access the data in the XmlDataDocument using a relational model.
The DataSet enables you to access the data in the XmlDataDocument using a relational model. This means that you can handle the data as tables and views, rows and columns, relations, and so on. Changes made in the DataSet are immediately visible in the XmlDataDocument.
The following example modifies the price of a book using the DataSet methods.
#using <System.dll> #using <System.Xml.dll> #using <System.Data.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" ); //Update the price on the first book using the DataSet methods. DataTable^ books = doc->DataSet->Tables[ "book" ]; books->Rows[ 0 ][ "price" ] = "12.95"; Console::WriteLine( "Display the modified XML data..." ); doc->Save( Console::Out ); }
The example uses the following two files as input.
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
Available since 1.1
Available since 1.1
Show: