XML Integration with ADO - XML Data Simplified
(Page 2 of 4 )
The following diagram contains different levels of data. First we have the Publishers, then for each publisher a list of employees and a list of sales. Subsequently for each sale, there is a list of books that were sold.
The above diagram is self explanatory. Let’s imagine that we have a hierarchical database in XML, say we want to enable it all to be viewed at once in the browser. What we are trying to achieve here is a top-level table containing just the Publishers. For each publisher, there should be two sub-tables. One is holding the values for the employee and other sales. For each sale, we try to maintain another table containing the details of the books sold. Let us assume each of these tables have been populated with some data.
From the above diagram it should be clear that, the only way we can bind to these relatively simple multi layers is to layer our binding. For the above XML, we would do the following to give nested tables. Let’s examine Example 2:
<TABLE ID = “tbPublishers” DATASRC= “#diPublishers” BORDER= “1”>
<TBODY>
<TR>
<TD><DIV DATAFLD= “pub_name”</DIV></TD>
<TD><DIV DATAFLD= “city”</DIV></TD>
<TD><DIV DATAFLD= “state”</DIV></TD>
</TR>
<TR>
<TD COLSPAN=4>
<TABLE >
<TR>
<TD>Titles</TD>
</TR>
<TR>
<TD COLSPAN=4>
<TABLE DATASRC= “#diPublishers” DATAFLD = “Title” Border= “1”>
<TR>
<TD><DIV DATAFLD= “title”</DIV></TD>
<TD><DIV DATAFLD= “price”</DIV></TD>
</TR>
<TR>
<TD COLSPAN=3>
<TABLE DATASRC= “#diPublishers” DATAFLD = “sale” Border= “1”>
<TR>
<TD><DIV DATAFLD= “ord_date”</DIV></TD>
<TD><DIV DATAFLD= “qty”</DIV></TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</TD>
</TR>
<TR>
<TD>Employee</TD>
</TR>
<TR>
<TD COLSPAN =4>
<TABLE DATASRC= “#diPublishers” DATAFLD = “Employee” Border= “1”>
<TR>
<TD><DIV DATAFLD= “fname”</DIV></TD>
<TD><DIV DATAFLD= “lname”</DIV></TD>
</TR>
</TABLE>
Next: Easy as 1,2,3 >>
More XML Articles
More By Gayathri Gokul
