reading xml values - C# Discussion Boards

6-Oct-07 9:25

I'm trying to read an xml file that appears to be valid xml, however, the attributes don't seem to be read by an System.Xml.XmlTextReader.

Any idea why?

I couldn't paste the .xml file here because it seems to corrupt the forum, but I can send it; it's a small file.

.NET Framework 2.0
Code
----

using System;

using System.Xml;

namespace ReadingXML2
{

    class Class1
    {

        static void Main(string[] args)
        {

            int ws = 0;

            int pi = 0;

            int dc = 0;

            int cc = 0;

            int ac = 0;

            int et = 0;

            int el = 0;

            int xd = 0;

            // Read a document

            XmlTextReader textReader = new XmlTextReader("sample.xml");

            // Read until end of file

            while (textReader.Read())
            {

                XmlNodeType nType = textReader.NodeType;

                // If node type us a declaration

                if (nType == XmlNodeType.XmlDeclaration)
                {

                    Console.WriteLine("Declaration:" + textReader.Name.ToString());

                    xd = xd + 1;

                }

                // if node type is a comment

                if (nType == XmlNodeType.Comment)
                {

                    Console.WriteLine("Comment:" + textReader.Name.ToString());

                    cc = cc + 1;

                }

                // if node type us an attribute

                if (nType == XmlNodeType.Attribute)
                {

                    Console.WriteLine("Attribute:" + textReader.Name.ToString());

                    ac = ac + 1;

                }

                // if node type is an element

                if (nType == XmlNodeType.Element)
                {

                    Console.WriteLine("Element:" + textReader.Name.ToString());

                    el = el + 1;

                }

                // if node type is an entity\

                if (nType == XmlNodeType.Entity)
                {

                    Console.WriteLine("Entity:" + textReader.Name.ToString());

                    et = et + 1;

                }

                // if node type is a Process Instruction

                if (nType == XmlNodeType.Entity)
                {

                    Console.WriteLine("Entity:" + textReader.Name.ToString());

                    pi = pi + 1;

                }

                // if node type a document

                if (nType == XmlNodeType.DocumentType)
                {

                    Console.WriteLine("Document:" + textReader.Name.ToString());

                    dc = dc + 1;

                }

                // if node type is white space

                if (nType == XmlNodeType.Whitespace)
                {

                    Console.WriteLine("WhiteSpace:" + textReader.Name.ToString());

                    ws = ws + 1;

                }

            }

            // Write the summary

            Console.WriteLine("Total Comments:" + cc.ToString());

            Console.WriteLine("Total Attributes:" + ac.ToString());

            Console.WriteLine("Total Elements:" + el.ToString());

            Console.WriteLine("Total Entity:" + et.ToString());

            Console.WriteLine("Total Process Instructions:" + pi.ToString());

            Console.WriteLine("Total Declaration:" + xd.ToString());

            Console.WriteLine("Total DocumentType:" + dc.ToString());

            Console.WriteLine("Total WhiteSpaces:" + ws.ToString());

        }

    }

}

Program output
--------------
Element:database
WhiteSpace:
Element:table
WhiteSpace:
Element:column
WhiteSpace:
WhiteSpace:
Element:column
WhiteSpace:
WhiteSpace:
Element:column
WhiteSpace:
WhiteSpace:
WhiteSpace:
Element:table
WhiteSpace:
Element:column
WhiteSpace:
WhiteSpace:
Element:column
WhiteSpace:
WhiteSpace:
WhiteSpace:
WhiteSpace:
Total Comments Blush | :O

Total Attributes Blush | :O

Total Elements:8
Total Entity Blush | :O

Total Process Instructions Blush | :O

Total Declaration Blush | :O

Total DocumentType Blush | :O

Total WhiteSpaces:16
Press any key to continue . . .

Jon

pmarfleet6-Oct-07 11:44

pmarfleet

6-Oct-07 11:44

Check 'Ignore HTML tags in this message' to post your XML.

Paul Marfleet

jon-806-Oct-07 13:09

6-Oct-07 13:09

I posted the .xml file I think...

Jon

jon-806-Oct-07 21:21

6-Oct-07 21:21

<?xml version="1.0"?>
<database schema-name='products'>
<table name='ProductsInStock'>
<column data-type='text' name='Code' pk='true' fkreferences='Product.Code'>
</column>
<column data-type='int' name='Qty'>
</column>
<column data-type='currency' name='CostPrice'>
</column>
</table>
<table name='Product'>
<column data-type='text' name='ProductID' pk='true'>
</column>
<column data-type='text' name='Description'>
</column>
</table>
</database>

Jon

pmarfleet6-Oct-07 22:06

pmarfleet

6-Oct-07 22:06

This code should work

static void Main(string[] args)        
        {
            int ws = 0;  
            int pi = 0;  
            int dc = 0;        
            int cc = 0;       
            int ac = 0;       
            int et = 0;       
            int el = 0;       
            int xd = 0;       
            // Read a document  
            XmlTextReader textReader = new XmlTextReader("../../sample.xml");     
            // Read until end of file     
            while (textReader.Read())        
            {            
                XmlNodeType nType = textReader.NodeType;
                // If node type us a declaration  
                if (nType == XmlNodeType.XmlDeclaration)           
                {                  
                    Console.WriteLine("Declaration:" + textReader.Name.ToString());     
                    xd = xd + 1;         
                }             
                // if node type is a comment  
                if (nType == XmlNodeType.Comment)        
                {            
                    Console.WriteLine("Comment:" + textReader.Name.ToString());                          
                    cc = cc + 1;      
                }                         
                // if node type is an element   
                if (nType == XmlNodeType.Element)  
                {                   
                    Console.WriteLine("Element:" + textReader.Name.ToString());    
                    el = el + 1;
                    if (textReader.HasAttributes)
                    {
                        while (textReader.MoveToNextAttribute())
                        {
                            Console.WriteLine("Attribute:" + textReader.Name.ToString());
                            ac = ac + 1;
                        }
                    }
                }         
                // if node type is an entity\ 
                if (nType == XmlNodeType.Entity)   
                {                
                    Console.WriteLine("Entity:" + textReader.Name.ToString());   
                    et = et + 1;      
                }           
                // if node type is a Process Instruction      
                if (nType == XmlNodeType.Entity)      
                {            
                    Console.WriteLine("Entity:" + textReader.Name.ToString());  
                    pi = pi + 1;            
                }               
                // if node type a document         
                if (nType == XmlNodeType.DocumentType)   
                {                   
                    Console.WriteLine("Document:" + textReader.Name.ToString());       
                    dc = dc + 1;    
                }             
                // if node type is white space     
                if (nType == XmlNodeType.Whitespace)       
                {                 
                    Console.WriteLine("WhiteSpace:" + textReader.Name.ToString());   
                    ws = ws + 1;      
                }      
            }          
            // Write the summary  
            Console.WriteLine("Total Comments:" + cc.ToString());      
            Console.WriteLine("Total Attributes:" + ac.ToString());   
            Console.WriteLine("Total Elements:" + el.ToString());     
            Console.WriteLine("Total Entity:" + et.ToString());      
            Console.WriteLine("Total Process Instructions:" + pi.ToString());     
            Console.WriteLine("Total Declaration:" + xd.ToString());        
            Console.WriteLine("Total DocumentType:" + dc.ToString());     
            Console.WriteLine("Total WhiteSpaces:" + ws.ToString());      
        }

The XmlTextReader has specific methods for iterating through Attributes. Use these when you encounter an Element node.

Paul Marfleet

jon-806-Oct-07 22:20

Is there a way to change file location?

6-Oct-07 22:20

Thanks.

Basically rather than use the XmlNodeType.Attribute to read attributes, the code should iterate through the attributes within each element to process them:

if (textReader.HasAttributes)
                    {
                        while (textReader.MoveToNextAttribute())
                        {
                            Console.WriteLine("Attribute:" + textReader.Name.ToString());
                            ac = ac + 1;
                        }
                    }

Jon

C# Beginner Nick6-Oct-07 9:04

6-Oct-07 9:04

I edited an old project and saved it as a new name, but everytime i move the project to a new folder with it's new name it gives me an error saying cannot find the file.

When i put it back to the old folder and open it, it shows that the current location is C:\Documents and Settings\Nick\Desktop\My Programs\Halo.sln but I can't change the location, Any one know how to change it?

Re: Is there a way to change file location? [modified]

Kristian Sixhøj6-Oct-07 9:18

Kristian Sixhøj

6-Oct-07 9:18

Try saving the whole solution in another location.
If you just move the solution-folder, your IDE will get confused and
can't find the files that are listed in the file [solution name].sln.

Virtual1ty

"Any fool can learn from his own mistakes, but a wise man learns from mistakes of others"

C# Beginner Nick6-Oct-07 9:20

6-Oct-07 9:20

Alright, I'll try that.

-- modified at 15:29 Saturday 6th October, 2007

Can't save the whole solution to a new folder, Looked threw every menu but there is only a Save Save As Save All no Save All As

-- modified at 15:30 Saturday 6th October, 2007

Btw, i'm using Visual Basics C# Express Edition

Kristian Sixhøj6-Oct-07 9:44

Kristian Sixhøj

6-Oct-07 9:44

Allright, this is probably a stupid way to do it, but it should work.

First, move the project to the location where you want it to be
(just move the whole folder).
Then do this in Visual Basic C# Express Edition:

On the File menu, select New -> Project from existing code...
Then find the folder that you just moved, and type the path in the
"Where are the files?" textbox, and check the "Include subfolders" checkbox.

The project will then be created at the new location.

Note: I haven't tried this, but it should work.

Virtual1ty

"Any fool can learn from his own mistakes, but a wise man learns from mistakes of others"

C# Beginner Nick6-Oct-07 9:59

6-Oct-07 9:59

Alright, i'll give it a try.

Patrick Etc.7-Oct-07 1:17

Patrick Etc.

7-Oct-07 1:17

Easiest way to do this:

Open your solution. While the solution is open, delete the .sln file in Explorer.

Build your project by going to the Build menu. Before it will build, it will prompt you to save the sln file. Save it to the location of your choosing.

Note, this only works on VS2005. VS2003 will probably barf.

The early bird who catches the worm works for someone who comes in late and owns the worm farm. -- Travis McGee

How do i....

C# Beginner Nick6-Oct-07 7:21

6-Oct-07 7:21

How do I set the menu strip to a picture and when I right click it, it will open the menu up?

Smile | :)

<-- Like an image like that and you right click it, it opens a menu.

Justin Perez6-Oct-07 7:25

Justin Perez

6-Oct-07 7:25

Attach a context menu to the click event of your image Smile | :)

I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")

C# Beginner Nick6-Oct-07 7:28

6-Oct-07 7:28

Thanks,
Can't figure out what to type, is it:
System.Windows.Forms.ContextMenuStrip; ?

Justin Perez6-Oct-07 7:45

Justin Perez

6-Oct-07 7:45

Yes sir. You can do a drag and drop from the designer toolbox, or you can do it like so:

{
     System.Windows.Forms.ContextMenuStrip cmuMenu = new ContextMenuStrip();
}

I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")

C# Beginner Nick6-Oct-07 7:48

6-Oct-07 7:48

Ok thank you very much.