DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 313649 - Last Review: October 29, 2012 - Revision: 7.0

This article was previously published under Q313649

On This Page

Summary

This article provides a roadmap to understand the integration of Extensible Markup Language with ADO.NET.

To assist you with learning a Microsoft product or technology, roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and white papers.

Overview

Often programmers must integrate XML with relational data. The Microsoft .NET Framework recognizes this need and can integrate ADO.NET with XML at multiple levels. Two key classes facilitate this integration: the DataSet class and the XmlDataDocument class. These classes provide two different views on that same data: hierarchical view and relational view.

DataSet can be populated from a relational backend or XML backend. This provides a relational view on the data. After DataSet is populated, regardless of the choice of backend, you can extract XML data from it.

XmlDataDocument provides a bridge between hierarchical and relational views. It binds with a DataSet to provide an XML view on the same data. As a result, all XML services [such as Extensible Stylesheets Language Transformations (XSLT) and XML Path Language (XPath)] are available on relational data.

You can save or load the structure of a DataSet as XML schema. In addition, you can use XML schemas to make typed DataSet classes. As the name implies, a typed DataSet is strongly typed and can access tables and columns by name instead of collection-based methods.

For more specific information about XML and the DataSet class, refer to the "XML and the DataSet" topics in the Visual Studio .NET Online Help documentation.

For an overview of ADO.NET integration with XML, refer to the following MSDN Magazine article:
Introducing ADO+: data access services for the Microsoft .NET Framework
http://msdn.microsoft.com/msdnmag/issues/1100/adoplus/default.aspx (http://msdn.microsoft.com/msdnmag/issues/1100/adoplus/default.aspx)

Walkthroughs

Walkthroughs provide short tutorials and hands-on instructions that walk you through typical application development scenarios. To access the walkthroughs on this topic, refer to the Visual Studio .NET Online Help documentation:
  1. In Visual Studio .NET, on the Help menu, click Contents.
  2. Click to expand the following nodes:
    • Visual Studio .NET
    • Visual Basic and Visual C#
    • Accessing Data
    • XML Schemas and Data
    • XML Walkthroughs
You can also use the Search feature on Help menu, and use the Walkthrough and XML keywords to search for walkthroughs.

Microsoft Knowledge Base How To articles

Microsoft Knowledge Base How To articles provide step-by-step instructions to accomplish a specific task.
309702  (http://support.microsoft.com/kb/309702/ ) How to read XML data into a DataSet by using Visual Basic .NET
311566  (http://support.microsoft.com/kb/311566/ ) How to read XML data into a DataSet by using Visual C# .NET
307224  (http://support.microsoft.com/kb/307224/ ) How to use XML in connected and disconnected ADO.NET applications
308064  (http://support.microsoft.com/kb/308064/ ) How to persist an ADO.NET DataSet as XML by using Visual Basic .NET
309183  (http://support.microsoft.com/kb/309183/ ) How to persist an ADO.NET DataSet as XML by using Visual C# .NET
310345  (http://support.microsoft.com/kb/310345/ ) How to render DataTable columns as XML attributes by using Visual Basic .NET
311937  (http://support.microsoft.com/kb/311937/ ) How to render DataTable columns as XML attributes instead of elements by using C# .NET
301271  (http://support.microsoft.com/kb/301271/ ) How to save a DataSet class as XML in .NET Framework SDK
311570  (http://support.microsoft.com/kb/311570/ ) How to read XML data into dataset by using Visual C++ .NET
309184  (http://support.microsoft.com/kb/309184/ ) How to persist an ADO.NET DataSet into XML by using Visual C++ .NET
You can also perform the following search at the Microsoft Help and Support Web site
http://support.microsoft.com/search/?adv=1 (http://support.microsoft.com)
  
  • In the Search Product list, select More Products, click Others, and then select .NET Framework.
  • In the Using list, click Boolean (text contains AND/OR).
  • In the For text box, type the following Boolean query (or type a subset of the following Boolean query): kbXML AND (DataSet OR XmlDataDocument or SQL or ADO).

Troubleshooting

If you encounter problems and need answers to your questions, consult the MSDN newsgroups. The MSDN newsgroups are the best place to obtain answers to your questions. In the MSDN newsgroups, you can share your experiences with your peers or search the Microsoft Knowledge Base for articles about specific issues:
MSDN Newsgroups
http://msdn.microsoft.com/newsgroups/ (http://msdn.microsoft.com/newsgroups/)

Searching the Knowledge Base
http://support.microsoft.com/search (http://support.microsoft.com/search)

microsoft.public.dotnet.xml newsgroup
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?query=microsoft.public.dotnet.xml+&dg=&cat=en_US_d02fc761-3f6b-402c-82f6-ba1a8875c1a7&lang=en&cr=&pt=&catlist=&dglist=&ptlist=&exp=&sloc=en-us (http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?query=microsoft.public.dotnet.xml+&dg=&cat=en_US_d02fc761-3f6b-402c-82f6-ba1a8875c1a7&lang=en&cr=&pt=&catlist=&dglist=&ptlist=&exp=&sloc=en-us)
 

References

For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
313828  (http://support.microsoft.com/kb/313828/ ) Roadmap for executing XPath queries in .NET applications
313816  (http://support.microsoft.com/kb/313816/ ) Roadmap for programming XML with the pull-model parser in the .NET Framework
313824  (http://support.microsoft.com/kb/313824/ ) Roadmap for programming XML with the DOM-model parser in the .NET Framework
313826  (http://support.microsoft.com/kb/313826/ ) Roadmap for XML schemas in the .NET Framework
301271  (http://support.microsoft.com/kb/301271/ ) How to save a DataSet class as XML in .NET Framework SDK
309184  (http://support.microsoft.com/kb/309184/ ) How to persist an ADO.NET DataSet into XML by using Visual C++ .NET
For more information and other Microsoft Roadmap articles, click the following article numbers to view the articles in the Microsoft Knowledge Base:
313651  (http://support.microsoft.com/kb/313651/ ) Roadmap for XML in the .NET Framework
314150  (http://support.microsoft.com/kb/314150/ ) Roadmap for XML serialization in the .NET Framework
313997  (http://support.microsoft.com/kb/313997/ ) Roadmap for executing XSLT transformations in .NET applications

Applies to
  • Microsoft .NET Framework 1.1
Keywords: 
kbarttyperoadmap kbinfo kbwebservices KB313649
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support