Read an XML file

[digitalshehan]

Hi All,

I have an xml file containing the following:
<?xml version="1.0" encoding="utf-8"?>
<Employee name="john" />
<Employee name="peter" />
<Employee name="mark" />

Can anyone let me know of away to read values from the xml file and add
them to an arraylist...

Thanks!

[digitalshehan]

just to add...

This is what i'm currently using:

XmlTextReader reader = new XmlTextReader(_fileName);
reader.WhitespaceHandling = WhitespaceHandling.None;

while(reader.Name != "Employee" && !reader.EOF)
reader.Read();

while(reader.Name == "Employee")
{
_shareCollection.Add(reader["name"]);
}

reader.Close();

Unfortunately, control never comes out of the while loop....

[Morten Wennevik]

Hi,

Well, first, this is not valid XML as it has multiple root elements. It
should be something like this instead

<?xml version="1.0" encoding="utf-8"?>
<Employees>
<Employee name="john" />
<Employee name="peter" />
<Employee name="mark" />
</Employees>

You can then load it into an XmlDocument and use SelectNodes to grab the
Employees, and then read the name attribute

XmlDocument doc = new XmlDocument();
doc.Load(@"C:\Employees.xml");

XmlNodeList elements = doc.SelectNodes("Employees/Employee");

ArrayList list = new ArrayList();

foreach (XmlNode node in elements)
list.Add(node.Attributes["name"].Value);


On Wed, 30 Aug 2006 08:29:39 +0200, <di***********@gmail.comwrote:

Hi All,

I have an xml file containing the following:
<?xml version="1.0" encoding="utf-8"?>
<Employee name="john" />
<Employee name="peter" />
<Employee name="mark" />

Can anyone let me know of away to read values from the xml file and add
them to an arraylist...

Thanks!

--
Happy Coding!
Morten Wennevik [C# MVP]

[digitalshehan]

Thanks Morten!

Appreciate the help... :)
Morten Wennevik wrote:

Hi,

Well, first, this is not valid XML as it has multiple root elements. It
should be something like this instead

<?xml version="1.0" encoding="utf-8"?>
<Employees>
<Employee name="john" />
<Employee name="peter" />
<Employee name="mark" />
</Employees>

You can then load it into an XmlDocument and use SelectNodes to grab the
Employees, and then read the name attribute

XmlDocument doc = new XmlDocument();
doc.Load(@"C:\Employees.xml");

XmlNodeList elements = doc.SelectNodes("Employees/Employee");

ArrayList list = new ArrayList();

foreach (XmlNode node in elements)
list.Add(node.Attributes["name"].Value);


On Wed, 30 Aug 2006 08:29:39 +0200, <di***********@gmail.comwrote:

Hi All,

I have an xml file containing the following:
<?xml version="1.0" encoding="utf-8"?>
<Employee name="john" />
<Employee name="peter" />
<Employee name="mark" />

Can anyone let me know of away to read values from the xml file and add
them to an arraylist...

Thanks!

--
Happy Coding!
Morten Wennevik [C# MVP]

[Peter Bromberg [C# MVP]]

Morten,
Why is this invalid XML? I see an Employees root, and then multiple Employee
elements each with a name attribute. If I save this as "Test.xml" and load it
in Internet Exploder, it parses just fine.

Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Morten Wennevik" wrote:

Hi,

Well, first, this is not valid XML as it has multiple root elements. It
should be something like this instead

<?xml version="1.0" encoding="utf-8"?>
<Employees>
<Employee name="john" />
<Employee name="peter" />
<Employee name="mark" />
</Employees>

You can then load it into an XmlDocument and use SelectNodes to grab the
Employees, and then read the name attribute

XmlDocument doc = new XmlDocument();
doc.Load(@"C:\Employees.xml");

XmlNodeList elements = doc.SelectNodes("Employees/Employee");

ArrayList list = new ArrayList();

foreach (XmlNode node in elements)
list.Add(node.Attributes["name"].Value);


On Wed, 30 Aug 2006 08:29:39 +0200, <di***********@gmail.comwrote:

Hi All,

I have an xml file containing the following:
<?xml version="1.0" encoding="utf-8"?>
<Employee name="john" />
<Employee name="peter" />
<Employee name="mark" />

Can anyone let me know of away to read values from the xml file and add
them to an arraylist...

Thanks!

--
Happy Coding!
Morten Wennevik [C# MVP]

[Morten Wennevik]

Because, the original XML did NOT have an Employees root, but many
Employee roots.
On Wed, 30 Aug 2006 13:56:02 +0200, Peter Bromberg [C# MVP]
<pb*******@yahoo.nospammin.comwrote:

Morten,
Why is this invalid XML? I see an Employees root, and then multiple
Employee
elements each with a name attribute. If I save this as "Test.xml" and
load it
in Internet Exploder, it parses just fine.

Peter

--
Happy Coding!
Morten Wennevik [C# MVP]

[Peter Bromberg [C# MVP]]

Sorry,
It must have been your corrected version I was looking at!
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Morten Wennevik" wrote:

Because, the original XML did NOT have an Employees root, but many
Employee roots.
On Wed, 30 Aug 2006 13:56:02 +0200, Peter Bromberg [C# MVP]
<pb*******@yahoo.nospammin.comwrote:

Morten,
Why is this invalid XML? I see an Employees root, and then multiple
Employee
elements each with a name attribute. If I save this as "Test.xml" and
load it
in Internet Exploder, it parses just fine.

Peter

--
Happy Coding!
Morten Wennevik [C# MVP]