Displaying data from an .XML file

Question

1.00/5 (1 vote)

See more:

Hey,
I can't seem to find anything that could solve this for me, so i ask you guys. I'm trying to make a series of labels display some lines from an xml file. This is some of the file:

XML

<Record>
    <Field column="ID">7</Field>
    <Field column="TEST">HELLO</Field>
    <Field column="IS">True</Field>
    <Field column="POWER">725</Field>
    <Field column="GUID">00000011-01d1-4f7d-af31-6c65c302abe2</Field>
</Record>

This is just a cutout from the whole file. There is hundreds of these <Record></Record> parts, all with the same <Field column...> in them, but with different notes, which is what i want to put into my 6 labels. One for each.

I know nothing about XML files, but nothing of what i found around the web, could solve this...

Do you guys have an example of how i could do this?

-nikko4913

Posted 8-Mar-15 3:51am

Member 9824751

Updated 8-Mar-15 4:00am

phil.o

v2

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)

phil.o · Answer 1 · 2015-03-08T04:03:00

Solution 1

You may use XPath Navigation[^] to fullfill your needs.

Posted 8-Mar-15 4:03am

phil.o

Comments

Member 9824751 8-Mar-15 10:17am

Thanks for the reply, but i just have no idea what i need to change, write and such, to make the code work for me. Could you maybe give me an example of how that code should look like for me?

iProgramIt · Answer 2 · 2015-03-08T04:26:00

Solution 2

You could get each line, put in a textbox and then for each line there is, create a new label displaying the value and the tag of the xml file (of that line)

Perhaps see:
StackOverFlow - Best Way to read a textbox line by line
StackOverFlow - Adding A Control Or Controls In vb.net At Runtime (goto sol. 2)

If you don't want to make labels, just insert into the textbox!

To separate the tag from the label, use

VB

String.Replace(OldChar, NewChar)

If anymore help is required, just ask :|

Edit:
BackGroundWorker Would Help if there are hundreds of entries...

Edit 2, Code:

VB

textbox.visible=false
textbox.text=my.computer.filesystem.readalltext(FileLocationHere)
For Each strLine As string In textbox.text.split(vbnewline)
Dim prevlocx as integer = 100
Dim x as new label
x.text = strline
x.location = new point(prevlocx, 40)
myform.controls.add(x)
x+=15
Next

Implement a background worker if you want to.

Posted 8-Mar-15 4:26am

iProgramIt

Updated 8-Mar-15 4:42am

v6

Comments

Member 9824751 8-Mar-15 10:33am

Hey. This sounds like what i'm looking for. Could you maybe make a code example? You don't have to spend ages on it, but it would be nice if you could :) Thanks again

iProgramIt 8-Mar-15 10:35am

Ok, I'll edit this...

Member 9824751 8-Mar-15 10:57am

Thank you. I'm a little confused looking at the code, for an example i get an error at the x.text = strLine and the rest too.. Should i replace it with something?

iProgramIt 8-Mar-15 11:06am

What errors?

iProgramIt 8-Mar-15 11:14am

Also, the labels will go outside your form, so enable scrollbarsenabled=true

Member 9824751 8-Mar-15 11:10am

Errors:

1. 'myform' is not declared. It may be inaccessible due to its protection level.

2. Operator '+' is not defined for types 'System.Windows.Forms.Label' and 'Integer'.

iProgramIt 8-Mar-15 11:13am

Replace "myform" with Me
Replace line: x+=15 with prevlocx+=15

Member 9824751 8-Mar-15 11:36am

Now i get a texbox full of my xml data, but it's not sorted in any way.. So how do i extract the nodes and put them onto the labels?