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

Article translations Article translations
Article ID: 311937 - View products that this article applies to.
This article was previously published under Q311937
Expand all | Collapse all

On This Page

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.

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 C# .NET syntax
  • Extensible Markup Language (XML)
  • ADO.NET fundamentals and syntax

Create the Visual C# .NET Sample

  1. Create a new Visual C# Console Application project.
  2. Add the following code to the top of the Code window:
    using System;
    using System.Data;
    using System.Data.SqlClient;
    					
  3. Add the following code in the static void Main(string[] args) section:
    SqlConnection cnPubs = new SqlConnection("Data Source=<servername>;user id=<username>;
                           password=<Password>;Initial Catalog=Pubs;");
    SqlDataAdapter daAuthors = new SqlDataAdapter("Select * from Authors",cnPubs);
    
    DataSet ds = new DataSet();
    cnPubs.Open();
    
    daAuthors.Fill(ds,"Authors");
    DataTable dt ;
    dt = ds.Tables["Authors"];
    
    foreach (DataColumn dc in dt.Columns)
    	{
    	dc.ColumnMapping = MappingType.Attribute;
    	}
    ds.WriteXml(@"C:\Authors.xml");
    Console.WriteLine("Completed writing XML file, using a DataSet");
    Console.Read(); 
    					
  4. Modify the SqlConnection string as appropriate for your environment.
  5. 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.
  6. Open Authors.xml. Notice that all of the columns are created as attributes for each row.

Properties

Article ID: 311937 - Last Review: July 15, 2004 - Revision: 3.4
APPLIES TO
  • Microsoft ADO.NET 1.1
  • Microsoft ADO.NET 1.0
  • Microsoft Visual C# .NET 2003 Standard Edition
  • Microsoft Visual C# .NET 2002 Standard Edition
Keywords: 
kbhowtomaster kbsqlclient kbsystemdata KB311937

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com