Article ID: 310345
Article Last Modified on 7/14/2004
APPLIES TO
- Microsoft ADO.NET 1.1
- Microsoft ADO.NET 1.0
- Microsoft Visual Basic .NET 2003 Standard Edition
- Microsoft Visual Basic .NET 2002 Standard Edition
This article was previously published under Q310345
For a Microsoft Visual C# .NET version of this article, see 311937.
This article refers to the following Microsoft .NET Framework Class Library namespaces:
- System.Data
- System.Data.SqlClient
- System.Xml
IN THIS TASK
SUMMARY
This article demonstrates how to render DataTable columns as Extensible Markup Language (XML) attributes. A DataTable represents one table of in-memory relational data. You can create a DataTable and use it independently, or other Microsoft .NET Framework objects can use the DataTable, most commonly as a member of a DataSet object.
back to the top
Requirements
The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need:
- Microsoft Windows XP, Windows 2000, or Windows NT 4.0 Service Pack 6a
- Microsoft Visual Studio .NET
This article assumes that you are familiar with the following topics:
- Visual Basic .NET syntax
- Extensible Markup Language (XML)
- ADO.NET fundamentals and syntax
Steps to Create Visual Basic .NET Sample
- Start Microsoft Visual Studio .NET, and create a new Visual Basic Console Application project.
Add the following code to the top of the Code window:
Imports System.Data Imports System.Data.SqlClient
Add the following code in the Sub Main procedure:
Dim cnPubs As New SqlConnection("Data Source=<servername>;user id=<username>;" & _ "password=<password>;Initial Catalog=Pubs;") Dim daAuthors As New SqlDataAdapter("Select * from Authors", cnPubs) Dim ds As New DataSet() cnPubs.Open() daAuthors.Fill(ds, "Authors") Dim dc As DataColumn For Each dc In ds.Tables("Authors").Columns dc.ColumnMapping = MappingType.Attribute Next ds.WriteXml("c:\Authors.xml") Console.WriteLine("Completed writing XML file, using a DataSet") Console.Read()
- Modify the SqlConnection string as appropriate for your environment.
- Press the F5 key to build and run the application. The message "Completed writing XML file, using a DataSet" appears in the Console window. Notice that the Authors.xml file is created in the specified location.
- Open Authors.xml. Notice that all of the columns are created as attributes for each row.
Additional query words: display output
Keywords: kbhowtomaster kbsystemdata KB310345