How can I read some data from xml and display on label?

Tommy

Hi,
I cannot get over an issue that I am having and I've been stuck on it for days.
Basically, I have an xml file mydisp.xml
Here's content of it (please note, it's complete content of xml file, without '

I'd like to retrieve elements "status, timestarted, Pack title, Client name, CE runTime, Out Time" and display on my multiple labels.text;
However, I keep having many issues. It seems c# kickes many exceptions because xml has '=' symbol and it looks more like a string.
I'd like to use Linq or xPath methods for retrieving the data as it must be very fast.
Please, can somebody help me with the code? How can I write this code and place inside onFormLoad? What used System references I must use?
Thank you everyone for your help.
Tommy

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
This LINQ to SQL code should extract the values you want. It just remains to assign them to the appropriate Label's Text property:

// need this using directive if not already there

using System.Xml.Linq;

// in Form_Load

XElement Schedule = XElement.Load("tommy.xml"); // or whatever file's called
XElement Event = Schedule.Element("Event");
string status = (string)Event.Attribute("status");
string timestarted = (string)Event.Attribute("timestarted");
XElement Pack = Event.Element("Pack");
string title = (string)Pack.Attribute("title");
XElement Client = Pack.Element("Client");
string name = (string)Client.Attribute("name");
XElement CE = Client.Element("CE");
string runTime = (string)CE.Attribute("runTime");
XElement Out = Client.Element("Out");
string Time = (string)Out.Attribute("Time");
Tommy13y ago
Vulpes, I'm on it :)) Thank you again. Glad there's still people like you exist.
Vulpes13y ago
Glad I could help, Tommy :)

I'd recommend getting to grips with LINQ to XML which is simpler and more logical, IMO, than previous methods of navigating XML such as XmlDocument and XPath.
Tommy13y ago
Vulpes, Alright, I see. Thank you once again for very clear explanations and sharing your knowledge. With your help I now understood what I was doing wrong. Nice job, well done :)) Greetings
Vulpes13y ago
With this:

"some info" is the value of the 'here' attribute of the 'something' element.

whereas with this:

some info

"some info" is the value of the 'something' element itself.

So, yes, there is a significant difference between the two which any system of XML parsing needs to recognize.
Tommy13y ago
Vulpes,
Wow, I cannot believe it. This is really working. Thank you so much million times for the code.
I've spent few days on one thing and thought no matter anything I must keep myself positive and I shall get it right. But from your code it looks plain simple. Wow, positively shocked :D)
By the way, if that's not too much to ask, but c# was kicking exception because it is string and unable to accept '=' and 'whitespace' from xml. Is is really so much different if we have to some info ??
Thank you once again for the help and your time. I completely value it!! Amazing :))