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

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

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

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());
}

}

Read xml root node Parameters

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Read xml root node Parameters

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us