Microsoft KB Archive/310345

= How To Render DataTable Columns as XML Attributes Instead of Elements by Using Visual Basic .NET =

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
 * Requirements
 * Steps to Create Visual Basic .NET Sample



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

back to the top

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(&quot;Data Source= ;user id= ;&quot; & _                               &quot;password= ;Initial Catalog=Pubs;&quot;) Dim daAuthors As New SqlDataAdapter(&quot;Select * from Authors&quot;, cnPubs)

Dim ds As New DataSet cnPubs.Open daAuthors.Fill(ds, &quot;Authors&quot;)

Dim dc As DataColumn For Each dc In ds.Tables(&quot;Authors&quot;).Columns dc.ColumnMapping = MappingType.Attribute Next

ds.WriteXml(&quot;c:\Authors.xml&quot;)

Console.WriteLine(&quot;Completed writing XML file, using a DataSet&quot;) Console.Read  Modify the SqlConnection string as appropriate for your environment. Press the F5 key to build and run the application. The message &quot;Completed writing XML file, using a DataSet&quot; 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.</ol>

back to the top

Additional query words: display output

Keywords: kbhowtomaster kbsystemdata KB310345

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.