C#

using System;
using System.Xml;

namespace ReadXMLfromFile
{
    /// <summary>
    /// Summary description for Class1.
    /// </summary>
    class Class1
    {
        static void Main(string[] args)
        {
            XmlTextReader reader = new XmlTextReader("sample.xml");
            while (reader.Read())
            {
{
       switch (reader.NodeType) 
       {
           case XmlNodeType.Element: // The node is an element.
               Console.Write("<" + reader.Name);

               while (reader.MoveToNextAttribute()) // Read the attributes.
                Console.Write(" " + reader.Name + "='" + reader.Value + "'");
                Console.WriteLine(">");
               break;
            case XmlNodeType.Text: //Display the text in each element. SHOULD THIS READ THE TEXT VALUE OF NODES?
               Console.WriteLine (reader.Value);
               break;
            case XmlNodeType. EndElement: //Display the end of the element.
                Console.Write("");
                break;
       }}}}}}

(source: MSDN)

sample.xml
----------

<database schema-name="products">

	<column data-type="text" name="Code" pk="true" fkreferences="Product.Code">    column 1
	<column data-type="int" name="Qty">	  column 2
  <column data-type="currency" name="CostPrice">    column 3
	<table name="ProductsInStock">		</table>

	<column data-type="text" name="ProductID" pk="true">	column 1
  <column data-type="text" name="Description">	column 2
  <table name="Product">	</table>

------------------
 


 -- modified at 13:26 Saturday 29th September, 2007 


 -- modified at 5:24 Sunday 30th September, 2007 


 -- modified at 5:26 Sunday 30th September, 2007 

<div class="ForumSig">Jon</div>