Fill dropdownlist with XML

Hi, I'm new to XML and C#. I want to load a drowdown list with specific items from an XML-file. I want to fill it with all the persons where cityname=City1 (Person1, Person2, Person3 and Person4). The problem is that all the persons displays in the dropdownbox on one single row, instead of one person on each row.

Please help me

Here is my XML:

<city>

<cityname>City1cityname>

<citynr>111citynr>

<name>Person1name>

<name>Person2name>

<name>Person3name>

<name>Person4name>

person>

<major>

<firstname>Major1firstnamefirstname>

<lastname>Major1lastnamelastname>

major>

city>

<city>

<cityname>City2cityname>

<citynr>222citynr>

<name>Person5name>

<name>Person6name>

<name>Person7name>

<name>Person8name>

person>

<major>

<firstname>Major2firstnamefirstname>

<lastname>Major2firstnamelastname>

major>

city

My code:

XElement country = XElement.Load(Server.MapPath("myXML.xml"));

XElement city = (from p in country.Elements("city")

where p.Element("cityname").Value == "City1"

select p).First();

dropDownList.Items.Add(city.Element("person").Value);

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nettan Nida13y ago
Thanks a lot! That helped me
Vulpes13y ago
Try replacing this line:

dropDownList.Items.Add(city.Element("person").Value);

with these:

foreach (XElement name in city.Element("person").Elements("name"))
{
dropDownList.Items.Add(name.Value);
}