- Sams Teach Yourself XML in 21 Days, Third Edition
- Table of Contents
- About the Author
- Acknowledgments
- We Want to Hear from You!
- Introduction
- Part I: At a Glance
- Day 1. Welcome to XML
- All About Markup Languages
- All About XML
- Looking at XML in a Browser
- Working with XML Data Yourself
- Structuring Your Data
- Creating Well-Formed XML Documents
- Creating Valid XML Documents
- How XML Is Used in the Real World
- Online XML Resources
- Summary
- Q&A
- Workshop
- Day 2. Creating XML Documents
- Choosing an XML Editor
- Using XML Browsers
- Using XML Validators
- Creating XML Documents Piece by Piece
- Creating Prologs
- Creating an XML Declaration
- Creating XML Comments
- Creating Processing Instructions
- Creating Tags and Elements
- Creating CDATA Sections
- Handling Entities
- Summary
- Q&A
- Workshop
- Day 3. Creating Well-Formed XML Documents
- What Makes an XML Document Well-Formed?
- Creating an Example XML Document
- Understanding the Well-Formedness Constraints
- Using XML Namespaces
- Understanding XML Infosets
- Understanding Canonical XML
- Summary
- Q&A
- Workshop
- Day 4. Creating Valid XML Documents: DTDs
- All About DTDs
- Validating a Document by Using a DTD
- Creating Element Content Models
- Commenting a DTD
- Supporting External DTDs
- Handling Namespaces in DTDs
- Summary
- Q&A
- Workshop
- Declaring Attributes in DTDs
- Day 5. Handling Attributes and Entities in DTDs
- Specifying Default Values
- Specifying Attribute Types
- Handling Entities
- Summary
- Q&A
- Workshop
- Day 6. Creating Valid XML Documents: XML Schemas
- Using XML Schema Tools
- Creating XML Schemas
- Dissecting an XML Schema
- The Built-in XML Schema Elements
- Creating Elements and Types
- Specifying a Number of Elements
- Specifying Element Default Values
- Creating Attributes
- Summary
- Q&A
- Workshop
- Day 7. Creating Types in XML Schemas
- Restricting Simple Types by Using XML Schema Facets
- Creating XML Schema Choices
- Using Anonymous Type Definitions
- Declaring Empty Elements
- Declaring Mixed-Content Elements
- Grouping Elements Together
- Grouping Attributes Together
- Declaring all Groups
- Handling Namespaces in Schemas
- Annotating an XML Schema
- Summary
- Q&A
- Workshop
- Part I. In Review
- Well-Formed Documents
- Valid Documents
- Part II: At a Glance
- Day 8. Formatting XML by Using Cascading Style Sheets
- Our Sample XML Document
- Introducing CSS
- Connecting CSS Style Sheets and XML Documents
- Creating Style Sheet Selectors
- Using Inline Styles
- Creating Style Rule Specifications in Style Sheets
- Summary
- Q&A
- Workshop
- Day 9. Formatting XML by Using XSLT
- Introducing XSLT
- Transforming XML by Using XSLT
- Writing XSLT Style Sheets
- Using <xsl:apply-templates>
- Using <xsl:value-of> and <xsl:for-each>
- Matching Nodes by Using the match Attribute
- Working with the select Attribute and XPath
- Using <xsl:copy>
- Using <xsl:if>
- Using <xsl:choose>
- Specifying the Output Document Type
- Summary
- Q&A
- Workshop
- Day 10. Working with XSL Formatting Objects
- Introducing XSL-FO
- Using XSL-FO
- Using XSL Formatting Objects and Properties
- Building an XSL-FO Document
- Handling Inline Formatting
- Formatting Lists
- Formatting Tables
- Summary
- Q&A
- Workshop
- Part II. In Review
- Using CSS
- Using XSLT
- Using XSL-FO
- Part III: At a Glance
- Day 11. Extending HTML with XHTML
- Why XHTML?
- Writing XHTML Documents
- Validating XHTML Documents
- The Basic XHTML Elements
- Organizing Text
- Formatting Text
- Selecting Fonts: <font>
- Comments: <!-->
- Summary
- Q&A
- Workshop
- Day 12. Putting XHTML to Work
- Creating Hyperlinks: <a>
- Linking to Other Documents: <link>
- Handling Images: <img>
- Creating Frame Documents: <frameset>
- Creating Frames: <frame>
- Creating Embedded Style Sheets: <style>
- Formatting Tables: <table>
- Creating Table Rows: <tr>
- Formatting Table Headers: <th>
- Formatting Table Data: <td>
- Extending XHTML
- Summary
- Q&A
- Workshop
- Day 13. Creating Graphics and Multimedia: SVG and SMIL
- Introducing SVG
- Creating an SVG Document
- Creating Rectangles
- Adobe's SVG Viewer
- Using CSS Styles
- Creating Circles
- Creating Ellipses
- Creating Lines
- Creating Polylines
- Creating Polygons
- Creating Text
- Creating Gradients
- Creating Paths
- Creating Text Paths
- Creating Groups and Transformations
- Creating Animation
- Creating Links
- Creating Scripts
- Embedding SVG in HTML
- Introducing SMIL
- Summary
- Q&A
- Workshop
- Day 14. Handling XLinks, XPointers, and XForms
- Introducing XLinks
- Beyond Simple XLinks
- Introducing XPointers
- Introducing XBase
- Introducing XForms
- Summary
- Workshop
- Part III. In Review
- Part IV: At a Glance
- Day 15. Using JavaScript and XML
- Introducing the W3C DOM
- Introducing the DOM Objects
- Working with the XML DOM in JavaScript
- Searching for Elements by Name
- Reading Attribute Values
- Getting All XML Data from a Document
- Validating XML Documents by Using DTDs
- Summary
- Q&A
- Workshop
- Day 16. Using Java and .NET: DOM
- Using Java to Read XML Data
- Finding Elements by Name
- Creating an XML Browser by Using Java
- Navigating Through XML Documents
- Writing XML by Using Java
- Summary
- Q&A
- Workshop
- Day 17. Using Java and .NET: SAX
- An Overview of SAX
- Using SAX
- Using SAX to Find Elements by Name
- Creating an XML Browser by Using Java and SAX
- Navigating Through XML Documents by Using SAX
- Writing XML by Using Java and SAX
- Summary
- Q&A
- Workshop
- Day 18. Working with SOAP and RDF
- Introducing SOAP
- A SOAP Example in .NET
- A SOAP Example in Java
- Introducing RDF
- Summary
- Q&A
- Workshop
- Part IV. In Review
- Part V: At a Glance
- Day 19. Handling XML Data Binding
- Introducing DSOs
- Binding HTML Elements to HTML Data
- Binding HTML Elements to XML Data
- Binding HTML Tables to XML Data
- Accessing Individual Data Fields
- Binding HTML Elements to XML Data by Using the XML DSO
- Binding HTML Tables to XML Data by Using the XML DSO
- Searching XML Data by Using a DSO and JavaScript
- Handling Hierarchical XML Data
- Summary
- Q&A
- Workshop
- Day 20. Working with XML and Databases
- XML, Databases, and ASP
- Storing Databases as XML
- Using XPath with a Database
- Introducing XQuery
- Summary
- Q&A
- Workshop
- Day 21. Handling XML in .NET
- Creating and Editing an XML Document in .NET
- From XML to Databases and Back
- Reading and Writing XML in .NET Code
- Using XML Controls to Display Formatted XML
- Creating XML Web Services
- Summary
- Q&A
- Workshop
- Part V. In Review
- Appendix A. Quiz Answers
- Quiz Answers for Day 1
- Quiz Answers for Day 2
- Quiz Answers for Day 3
- Quiz Answers for Day 4
- Quiz Answers for Day 5
- Quiz Answers for Day 6
- Quiz Answers for Day 7
- Quiz Answers for Day 8
- Quiz Answers for Day 9
- Quiz Answers for Day 10
- Quiz Answers for Day 11
- Quiz Answers for Day 12
- Quiz Answers for Day 13
- Quiz Answers for Day 14
- Quiz Answers for Day 15
- Quiz Answers for Day 16
- Quiz Answers for Day 17
- Quiz Answers for Day 18
- Quiz Answers for Day 19
- Quiz Answers for Day 20
- Quiz Answers for Day 21
Introducing DSOs
We can use Internet Explorer for all kinds of data binding, as you're going to see today, and that's great if data is stored in XML format and we want to display it to the user on the Internet. Internet Explorer connects to XML and HTML documents that store data using the ActiveX Data Objects (ADO) protocol (not the ADO.NET protocol of the .NET Framework).
We'll start by taking a look at general data binding in Internet Explorer, and then we'll examine more specialized data binding in XML. To bind the data in an XML or HTML document to HTML controls in a Web page, we use one of the four DSOs available in Internet Explorer—the Microsoft HTML (MSHTML) control, XML data islands, the tabular data control (TDC), or the XML DSO applet. Two of these DSOs, the XML DSO and XML data islands, support XML documents.
DSOs don't appear visually themselves—they just connect to a document and make the data in that document available to the controls in a Web page. For example, let's take a look at the HTML document in Listing 19.1 (ch19_01.html). This HTML document holds the states data you saw on Day 10, "Working with XSL Formatting Objects" (compare ch19_01.html to ch10_01.xml, for example)—the names of various states, their populations, capitals, state birds, and so on. In HTML we use <SPAN> or <DIV> elements to mimic XML elements, naming the "element" by assigning a value to the ID attribute. For example, the <name> element in ch10_01.xml becomes the <SPAN ID="name"> element here.
Example 19.1. An HTML Document That Holds Data (ch19_01.html)
<HTML> <HEAD> <TITLE> State Data </TITLE> </HEAD> <BODY> Name: <SPAN ID="name"> California </SPAN><BR> Population: <SPAN ID="population"> 33871648 </SPAN><BR> Capital: <SPAN ID="Capital"> Sacramento </SPAN><BR> Bird: <SPAN ID="bird">Quail</SPAN><BR> Flower: <SPAN ID="flower"> Golden Poppy </SPAN><BR> Name: <SPAN ID="name"> Massachusetts </SPAN><BR> Population: <SPAN ID="population"> 6349097 </SPAN><BR> Capital: <SPAN ID="Capital"> Boston </SPAN><BR> Bird: <SPAN ID="bird">Chickadee</SPAN><BR> Flower: <SPAN ID="flower"> Mayflower </SPAN><BR> Name: <SPAN ID="name"> New York </SPAN><BR> Population: <SPAN ID="population"> 18976457 </SPAN><BR> Capital: <SPAN ID="Capital"> Albany </SPAN><BR> Bird: <SPAN ID="bird">Bluebird</SPAN><BR> Flower: <SPAN ID="flower"> Rose </SPAN><BR> </BODY> </HTML>
We'll use the MSHTML DSO, the simplest of the DSOs, to read in the data from ch19_01.html and bind that data to HTML controls so we can display that data in those controls. When we bind the data in a document such as ch19_01.html with a DSO, that DSO handles the data in records and creates a record set that is accessible from the HTML control in the Web page. For example, here's what the record for New York looks like:
Name: <SPAN ID="name"> New York </SPAN><BR> Population: <SPAN ID="population"> 18976457 </SPAN><BR> Capital: <SPAN ID="Capital"> Albany </SPAN><BR> Bird: <SPAN ID="bird">Bluebird</SPAN><BR> Flower: <SPAN ID="flower"> Rose </SPAN>
This record has five fields—name, population, capital, bird, and flower—each of which store data. By using Internet Explorer <OBJECT> element, create an MSHTML DSO and bind it to employee.htm; here, you'll name this DSO states:
<OBJECT ID="states" DATA="ch19_01.html" HEIGHT="0" WIDTH="0"> </OBJECT>
The DSO will read and interpret ch19_01.html and convert that document into an ADO record set, making that record set available to the rest of the HTML page. (The record set that is created is read-only, and it is called an ADOR record set.) The DSO holds data from only one record at a time, and that record is called the current record. We can use the built-in methods of a record set to navigate through data by making other records the current record; some common methods are moveFirst, moveLast, moveNext, and movePrevious, which let us navigate from record to record, and you're going to see these methods today. To actually display the data from this DSO, we can bind it to HTML elements.