Article ID: 313649
Article Last Modified on 6/7/2006
APPLIES TO
- Microsoft .NET Framework 1.1 Service Pack 1
- Microsoft .NET Framework 1.1
This article was previously published under Q313649
CONTENTS
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.
back to the top
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
Architecture
For architectural (or internal) information about XmlDataDocument and DataSet integration, refer to the following Microsoft Web site:
How do I...use XML and the DataSet?
http://samples.gotdotnet.com/quickstart/howto/doc/xml/xmldataset.aspx
Quickstart Tutorials
For ADO.NET and XML Quickstart tutorials, refer to the following Microsoft Web sites:
How do I...read and write XML?
http://samples.gotdotnet.com/quickstart/howto/default.aspx?url=/quickstart/howto/doc/adoplus/readandwritexml.aspx
How do I...generate XML with data from SQL Server?
http://samples.gotdotnet.com/quickstart/howto/default.aspx?url=/quickstart/howto/doc/adoplus/xmlfromsqlsrv.aspx
How do I...load a DataSet with XML?
http://samples.gotdotnet.com/quickstart/howto/default.aspx?url=/quickstart/howto/doc/xml/loaddatasetxmldata.aspx
How do I...save a DataSet as XML?
http://samples.gotdotnet.com/quickstart/howto/default.aspx?url=/quickstart/howto/doc/xml/savedatasetxml.aspx
How do I...create DataSet mappings from an XSD schema?
http://samples.gotdotnet.com/quickstart/howto/default.aspx?url=/quickstart/howto/doc/xml/datasetmapxsdschema.aspx
How do I...save DataSet mappings to an XSD schema file?
http://samples.gotdotnet.com/quickstart/howto/default.aspx?url=/quickstart/howto/doc/xml/savedatasetmapxsdschema.aspx
How do I...load XML data into an XmlDataDocument?
http://samples.gotdotnet.com/quickstart/howto/default.aspx?url=/quickstart/howto/doc/xml/loadxmldocument.aspx
How do I...read XML from an XmlDataDocument?
http://samples.gotdotnet.com/quickstart/howto/default.aspx?url=/quickstart/howto/doc/xml/streamxmldocument.aspx
How do I...infer DataSet mappings from XML?
http://samples.gotdotnet.com/quickstart/howto/doc/Xml/DataSetMapXMLData.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:
- In Visual Studio .NET, on the Help menu, click Contents.
- 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.
back to the top
Microsoft Knowledge Base How To articles
Microsoft Knowledge Base How To articles provide step-by-step instructions to accomplish a specific task.
309702 How to read XML data into a DataSet by using Visual Basic .NET
311566 How to read XML data into a DataSet by using Visual C# .NET
307224 How to use XML in connected and disconnected ADO.NET applications
308064 How to persist an ADO.NET DataSet as XML by using Visual Basic .NET
309183 How to persist an ADO.NET DataSet as XML by using Visual C# .NET
310345 How to render DataTable columns as XML attributes by using Visual Basic .NET
311937 How to render DataTable columns as XML attributes instead of elements by using C# .NET
301271 How to save a DataSet class as XML in .NET Framework SDK
311570 How to read XML data into dataset by using Visual C++ .NET
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
- 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/
Searching the Knowledge Base
http://support.microsoft.com/search
microsoft.public.dotnet.xml newsgroup
http://msdn.microsoft.com/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microsoft.public.dotnet.xml
NOTE: If you already subscribed to the microsoft.public.dotnet.xml newsgroup, you can access the newsgroup from the following URL:
You can also post questions on this topic to following ADO.NET newsgroup:
microsoft.public.dotnet.framework.adonet newsgroup
http://msdn.microsoft.com/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microsoft.public.dotnet.framework.adonet
NOTE: If you already subscribed to the microsoft.public.dotnet.framework.adonet newsgroup, you can access the newsgroup from the following URL:
REFERENCES
For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
313828 Roadmap for executing XPath queries in .NET applications
313816 Roadmap for programming XML with the pull-model parser in the .NET Framework
313824 Roadmap for programming XML with the DOM-model parser in the .NET Framework
313826 Roadmap for XML schemas in the .NET Framework
301271 How to save a DataSet class as XML in .NET Framework SDK
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 Roadmap for XML in the .NET Framework
314150 Roadmap for XML serialization in the .NET Framework
313997 Roadmap for executing XSLT transformations in .NET applications
Keywords: kbinfo kbarttyperoadmap kbwebservices KB313649