XML
  Home arrow XML arrow Page 4 - Displaying ADO Retrieved Data with XML Isl...
Dev Articles Forums 
ADO.NET  
Apache  
ASP  
ASP.NET  
C#  
C++  
ColdFusion  
COM/COM+  
Delphi-Kylix  
Design Usability  
Development Cycles  
DHTML  
Embedded Tools  
Flash  
Graphic Design  
HTML  
IIS  
Interviews  
Java  
JavaScript  
MySQL  
Oracle  
Photoshop  
PHP  
Reviews  
Ruby-on-Rails  
SQL  
SQL Server  
Style Sheets  
VB.Net  
Visual Basic  
Web Authoring  
Web Services  
Web Standards  
XML  
Dedicated Servers  
Actuate Whitepapers 
VeriSign Whitepapers 
IBM® developerWorks 
Sun Developer Network 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
XML

Displaying ADO Retrieved Data with XML Islands
By: Jayaram Krishnaswamy
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 3
    2006-09-06

    Table of Contents:
  • Displaying ADO Retrieved Data with XML Islands
  • Extracting XML formatted data example
  • The Saved XML file
  • Reviewing the saved file
  • Data types in Access 2003 and XML file
  • Displaying retrieved XML in an HTML document
  • Creating an HTML document which can display the XML Data

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
    Iron Speed
     
    ADVERTISEMENT

    Free Web 2.0 Code Generator! Generate data entry and reporting .NET Web apps in minutes. Quickly create visually stunning, feature-rich apps that are easy to customize and ready to deploy. Download Now!

    Displaying ADO Retrieved Data with XML Islands - Reviewing the saved file


    (Page 4 of 7 )

    Although the file is large, it consists basically of two parts, as shown in the browser display of this file after collapsing all the details. As seen in the next picture, the file's two parts are the 'Schema' and the 'Data' represented by their prefixes, 's:' and 'rs:' as shown in the namespaces -- the first four lines in the document which have the prefix xmlns.

    The schema section

    The next picture shows just one element from the expanded 's' node in the displayed XML file in the browser. You can also see that it is updatable. This particular slice corresponds to the 'Address' field of the Employees table shown in the first picture. The fields are listed alphabetically in the persisted file. The other elements also show the various attributes of the Address field. In the original table, the Address field's Data type is text and field size is 60. The XML attribute with the prefix 'dt' which marks the beginning of each row shows this information. The 'text' has become 'string' and the field size has become 'maxlength.' The schema information therefore is an accurate representation of the data structure.

    The Data Section

    The next section shows the only row of data taken from the data section. The prefix 'z' marks the beginning of the data. The XML file has only one row of the table returned corresponding to the LastName='Peacock.'

    More XML Articles
    More By Jayaram Krishnaswamy


       · ADO was indeed a milestone in Microsoft's data access technology. It replaced the...
     

    XML ARTICLES

    - Path, Predicates, and XQuery
    - Using Predicates with XQuery
    - Navigating Input Documents Using Paths
    - XML Basics
    - Introduction to XPath
    - Simple Web Syndication with RSS 2.0
    - Java UI Design with an IDE
    - UI Design with Java and XML Toolkits
    - Displaying ADO Retrieved Data with XML Islan...
    - Widget Walkthrough
    - Introduction to Widgets
    - The Why and How of XML Data Islands
    - Creating an XUL App Installer
    - Overlays in XUL
    - Skinning Your Custom XUL Applications


    Iron Speed





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway