Brent D. wrote:

> My problem is I need to extract the node names and values from the XML 
> document for use in a database.  I am fully aware of the XML classes in the 
> asp.net framework.  My problem has been finding a piece of sample code that 
> can iterate through ALL the nodes of any XML document.
> 
> If you have any sample code that does this using the XML classes of the 
> asp.net framework, please let me know.

Use XmlReader for instance, here is an example (writing to Console.Out 
but it shows how to use the XmlReader methods):

             using (XmlReader xmlReader = 
XmlReader.Create(@"..\..\XMLFile3.xml"))
             {
                 while (xmlReader.Read())
                 {
                     switch (xmlReader.NodeType)
                     {
                         case XmlNodeType.Element:
                             Console.Write(xmlReader.Name);
                             break;
                         case XmlNodeType.SignificantWhitespace:
                         case XmlNodeType.Whitespace:
                             Console.Write(xmlReader.Value);
                             break;
                         case XmlNodeType.Text:
                             Console.Write(" = {0}", xmlReader.Value);
                             break;
                     }
                 }
             }

Result applied on your sample XML (with the typo Neil found corrected) 
is as follows:

root
   node1 = value 1
   list
     node2 = value 2
     node3 = value 3

   node4 = value 4

Pretty much what you want. You will need to be more specific about the 
database stuff if you need more help, your original request said "the 
output would display", your last request talked about a database, it is 
not clear how that relates together. Hopefully the above code snippet 
does show you how to use XmlReader and you can add the code to store the 
data in a database yourself.


-- 

	Martin Honnen --- MVP XML
	http://JavaScript.FAQTs.com/