XML Integration with ADO
(Page 1 of 4 )
In a
previous article we looked at XML integrating with ADO and IE and some of the nice features that allow us to access a recordset as an XML document. In today’s tutorial we will be covering multiple levels of hierarchical XML data,illustrating some complex XML data binding examples and enumerating how to persist ADO recordsets to XML files as well as streams. We also discuss a much easier way of persisting ADO recordsets to response objects.
Let us dive right into the XML data pool and soak ourselves with a few sample codes. For starter consider the following code:
<XML ID = “diDataPublishers”>
<Publishers>
<Publisher>
<pub_id>001</pub_id>
<pub_name>McGraw Hill</pub_name>
<city>Berkeley</city>
<state>CA</state>
<country>USA</country>
<title>
<title_id>Mc1</title_id>
<title>HTML-Virtual Classroom.</title>
<price>$39.99</price>
<pub_date>5/24/02</pub_date>
<sale>
<store_id>9898</store_id>
<ord_num>H001</ord_num>
<ord_date>$39.99</ord_date>
<qty>30</qty>
</sale>
</title>
<employee>
<emp_id>JM01B</emp_id>
<fname> Henry<fname>
<midinl>M</midinl>
<lname>Ford<lname>
<emp_title>Manager</emp_title>
</employee>
<employee>
<emp_id>WC02S</emp_id>
<fname>William<fname>
<midinl>C</midinl>
<lname>Smith<lname>
<emp_title>Cashier</emp_title>
</employee>
Next: XML Data Simplified >>
More XML Articles
More By Gayathri Gokul
