Show Xml Data In ListView Control

Question

0.00/5 (No votes)

See more:

My XML File Is This... SendLimit.xml

HTML

<rule name="Sendlimit">
    <interface>
        <comment></comment>
        <fixParam name="USERID" type="String"/>
        <fixParam name="Account" type="String"/>
        <fixParam name="Product" type="Tradable"/>
        <chgParam name="Buy" type="Boolean"/>
        <chgParam name="Limit_Price" type="Number"/>
        <chgParam name="Quantity" type="Number"/>
        <overviewPE name="_LME">
            <value>_LME</value>
        </overviewPE>
        <overviewPE name="IsLME">
            <value>IsLME</value>
        </overviewPE>
        <overviewPE name="Counts">
            <value>Counts[0]</value>
        </overviewPE>
        <overviewPE name="Names">
            <value>Names[0]</value>
        </overviewPE>
        <detailedPE name="_LME">
            <value>_LME</value>
        </detailedPE>
    </interface>
</rule>

I tried as i can but didn't get result as i want..

i only want to read and show value like this.....

HTML

USERID    string
Account   string
Product   tradable

As on (Means Only Values)

Pls Help
Thank You...

Posted 15-May-13 21:31pm

Anjanee Kumar Singh

Add a Solution

Comments

Jegan Thiyagesan 16-May-13 7:32am

show us your code!

Anjanee Kumar Singh 16-May-13 7:36am

XmlTextReader rssReader = new XmlTextReader(Convert.ToString(dir)+"\\Final.xml");
XmlDocument rssDoc = new XmlDocument();
rssDoc.Load(rssReader);
XmlNodeList titleList = rssDoc.GetElementsByTagName("name");
XmlNodeList urlList = rssDoc.GetElementsByTagName("type");
ListViewItem lvi = new ListViewItem();

for (int i = 0; i < titleList.Count; i++)
{
listViewStaticVar.Items.Add(titleList[i].InnerXml);
}

for (int i = 0; i < urlList.Count; i++)
{
lvi.SubItems.Add(urlList[i].InnerXml);
}

listViewStaticVar.Items.Add(lvi);

Jegan Thiyagesan 16-May-13 13:11pm

what output are you getting for this code?

Anjanee Kumar Singh 17-May-13 1:24am

Nothing... But no error showing too..

Anjanee Kumar Singh 16-May-13 7:36am

This is My Code

But I want Simple Code

Mayur Panchal 17-May-13 2:45am

XmlNodeList titleList = rssDoc.GetElementsByTagName("name");
XmlNodeList urlList = rssDoc.GetElementsByTagName("type");

Above two lines are wrong. Because there is no tag with "name" and "type" name, those are attributes of tags.
We can see tag names are "fixParam", "chgParam" etc..
Let us know that which tags you need as output?

Anjanee Kumar Singh 17-May-13 2:48am

both fixparam and chgparam and overviewpe.

Is it possible to have value without knowing tag names ( i mean to say everything would be dynamic)

Thank you

Mayur Panchal 17-May-13 2:56am

It is possible but, there should be something fixed format, I mean to say root tag or the parent element of your start tag.
Let me explain : In above xml your first tag is 'rule' then 'interface', and you want to start with 'fixParam' tag. So the path would be fixed from where you want start or which will be your first element.

Anjanee Kumar Singh 17-May-13 2:59am

So if i have to start from root tag (i.e rule)

then how should i start coding to get the value of 'name' and 'type' and other values

Mayur Panchal 17-May-13 3:02am

Please, Confirm you want only those tag which have 'name' and 'type' attributes and others will be ignored. ??

Anjanee Kumar Singh 17-May-13 3:07am

name type
USERID string
Account string
Product tradable

Buy boolean
Limit_pri number
quantity number

and all OverviewPE ( Name and their Values)

1 solution

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)

Mayur Panchal · Accepted Answer · 2013-05-16T22:12:00

I have tried to implement something what you want :

//Code that you call at some event (i.e. button_click)
XmlTextReader rssReader = new XmlTextReader(Application.StartupPath + "\\Final.xml");
XmlDocument rssDoc = new XmlDocument();
rssDoc.Load(rssReader);

XmlNodeList nodeList = rssDoc.DocumentElement.ChildNodes;
foreach (XmlNode childNode in nodeList)
{
      AddToListView(childNode);
}

//Method implemented to read XML and add items to list view
private void AddToListView(XmlNode node)
{
    if (node != null && node.Attributes!=null && node.Attributes.Count > 0)
    {
        ListViewItem lvi = new ListViewItem();
        if (node.Attributes["name"] != null)
        {
            lvi.Text = node.Attributes["name"].Value;
        }
        if (node.Attributes["type"] != null)
        {
            lvi.SubItems.Add(node.Attributes["type"].Value);
        }
        else
        {
            if (node.ChildNodes != null && node.ChildNodes.Count > 0)
            {
                foreach (XmlNode vnode in node.ChildNodes)
                {
                    if (vnode.Name == "value")
                    {
                        lvi.SubItems.Add(vnode.InnerText);
                        break;
                    }
                }              
            }
        }
                
        listViewStaticVar.Items.Add(lvi);
    }
            
    if (!node.HasChildNodes)
        return;

    foreach (XmlNode chnode in node.ChildNodes)
    {
        AddToListView(chnode);
    } 
}