Read xml root node Parameters

Question

1.00/5 (1 vote)

See more:

Hi frnds..,

I have an task that the Root node parameter name should bind in an list box
(i.,e)

My xml File

XML

<?xml version="1.0" encoding="UTF-8"?>
-<catalog> -<book id="bk101"> <author>Gambardella, Matthew</author> <title>XML Developer's Guide</title> <genre>Computer</genre> <price>44.95</price> <publish_date>2000-10-01</publish_date> <description> An in-depth look at creating applications with XML. </description> </book> -<book id="bk102"> <author>Ralls, Kim</author> <title>Midnight Rain</title> <genre>Fantasy</genre> <price>5.95</price> <publish_date>2000-12-16</publish_date> <description> A former architect battles corporate zombies, an evil sorceress, and her own childhood to become queen of the world. </description> </book>

My Output in listbox should be as

book id
author
title
genre
price
publish_date
description

Is it possible if so pls give me some possible solutions Thank YOu

Posted 23-Jul-13 20:35pm

usha C

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jameel VM · Accepted Answer · 2013-07-23T21:29:00

Solution 1

Use LINQ to XML

C#

var doc = new XDocument();
doc.Load(something);
List<string> list=new List<string>();
foreach(var name in doc.Root.Element("catalog").DescendantNodes().OfType<XElement>()
        .Select(x => x.Name).Distinct())
{
    list.Add(name);
}

//Bind the list to Listbox

Hope this helps

Posted 23-Jul-13 21:29pm

Jameel VM

Updated 23-Jul-13 22:28pm

v2

Comments

usha C 24-Jul-13 4:02am

Thanks fr ur code sir am getting dis error...
my error is
"System.Xml.XmlDocument' does not contain a definition for 'Root' and no extension method 'Root' accepting a first argument of type 'System.Xml.XmlDocument' could be found (are you missing a using directive or an assembly reference?)"

I have used my namespaces
using System.Linq;
using System.Xml.Linq;

wat error is iits????

Jameel VM 24-Jul-13 4:27am

use XDocument instead of XmlDocument

usha C 24-Jul-13 5:00am

I jus modify ur code sir since i got some error in ur code
After the modification also i faced wit some error...........

XDocument doc = XDocument.Load("Book.xml");

List<string> list = new List<string>();
foreach (var name in doc.Root.Element("catalog").DescendantNodes().OfType<xelement>()
.Select(x => x.Name).Distinct())
{
ListBox1.Items.Add(name.ToString());
}

The error is
"Object reference not set to an instance of an object."
In my for loop

Jameel VM 24-Jul-13 5:03am

put like this{
list.Add(name);
}
ListBox1.DataSource=list;

Jameel VM 24-Jul-13 5:04am

Please verify the xml is loaded or not.may be doc is null that's why u got exception

Jameel VM 24-Jul-13 5:05am

please check a condition before iterating if(doc!=null){
//for loop here
}

usha C 24-Jul-13 5:08am

the xml is not null sir The loop is executing inside the if condition...

Jameel VM 24-Jul-13 5:15am

what is the value of name. is it null?

Jameel VM 24-Jul-13 5:06am

Please put a correct xml path

usha C 24-Jul-13 5:32am

Sir Thnks for ur code it helps to give me the exact result ...

I jus modify the code

XDocument doc = XDocument.Load("Book.xml");

if (doc != null)
{

foreach (var name in doc.Root.DescendantNodes().OfType<xelement>().Select(x => x.Name).Distinct())
{

ListBox1.Items.Add(name.ToString());
}

}

usha C · Accepted Answer · 2013-07-23T23:35:00

Solution 2

C#

XDocument doc = XDocument.Load("Book.xml"); if (doc != null) { foreach (var name in doc.Root.DescendantNodes().OfType().Select(x => x.Name).Distinct()) { ListBox1.Items.Add(name.ToString()); } }

It gives Exact result....

Posted 23-Jul-13 23:35pm

usha C