Bind XML data to a Dropdownlist c#

Question

I am trying to bind XML data to Dropdownlist

 XElement xDoc = XElement.Parse(QContent.OuterXml);

Here is what my xDoc contains

<root xmlns="">
       <item value="-1" text="Select" />
       <item value="1" text="$30,000" />
       <item value="2" text="$50,000" />
    </root>

Query to extract the data into a Listitem :

 var query = from xEle in xDoc.Descendants("root")
               select new ListItem(xEle.Attribute("value").Value , xEle.Attribute("text").Value);

This yields no results. Please advice.

Thanks in advance

BB

Do you have to do it this way? Can't you just create a dataset and Use the dataset to read the XML file and finally bind the dataset to the drop down list and you're done. — Standage
– Standage, Commented Jan 20, 2012 at 23:21

zx485 · Accepted Answer · 2017-02-27 21:44:01Z

2

Put your XML file inside App_Data or anywhere in program and in MapPath.
Assign their path and also assign the name of your first XML column in the last line.

Here I'm using "code" because it is my first XML column and country is the name of the column I want to show in my dropdownlist.

private void BindCountry()
{
    XmlDocument doc = new XmlDocument();
    doc.Load(Server.MapPath("~//App_Data//countries.xml"));

    foreach (XmlNode node in doc.SelectNodes("//country"))
    {
        ddlcountry.Items.Add(new ListItem(node.InnerText, node.Attributes["code"].InnerText));
    }
}

edited Feb 27, 2017 at 21:44

zx485

29.1k28 gold badges55 silver badges65 bronze badges

answered Feb 11, 2013 at 6:55

Rahul

5,6556 gold badges38 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

zx485 · Accepted Answer · 2017-02-27 21:46:34Z

2

You can change your LINQ query to the following which will return all the nodes under root and return new items with the value/text pairs that you are trying to bind to.

var query = from xEle in xDoc.Descendants()
select new {value = xEle.Attribute("value").Value , text = xEle.Attribute("text").Value};

Then set up your bindings as follows including collapsing the query to a list.

ddlList.DataValueField = "value";
ddlList.DataTextField = "text";
ddlList.DataSource = query.ToList();
ddlList.DataBind();

edited Feb 27, 2017 at 21:46

zx485

29.1k28 gold badges55 silver badges65 bronze badges

answered Jan 20, 2012 at 23:27

Mark Smith

1,1159 silver badges19 bronze badges

Collectives™ on Stack Overflow

Bind XML data to a Dropdownlist c#

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related