How to read XML attribute values ?

Question

Hi All How to read a XML attribute value in C# ? I have a XML doc as below stored in a file called Auto.xml in the same path as that of the solution. Pending Fault found on Repaired Fault on Aircraft Component Subsystem Now I want to check the node type i.e. if the node type is attribute and if the attribute value is pending then I want to return the corresponding text node value Pending Fault found on as a string array. But I don't know how to read the attribute value of a node. (I am using VS 2008) Thanks Sachi

Vulpes · Answer

It's not working properly now because you've placed both text nodes under a single fault node. Previously you had a single text node under each of two fault nodes. However this is easy to deal with: var query = from element in auto.Elements() where element.Name == fault select element; fault = (from element in query.Elements(text) select element.Value).ToArray();

sachi vasishta · Answer

Thanks Vulpes. Now its working exactly the way I was trying to get :) .

sachi vasishta · Answer

Hi the code var query = from element in auto.Elements() where element.Name == fault select element; fault = (from element in query select element.Element(text).Value).ToArray(); is returning only first child node value that is Pending Fault found on but if I type r/R its not picking the second child node value.. Pending Fault found on Repaired Fault on Aircraft Component Subsystem the element.Element(text).value returns the first child node of the element but how to get the second one (Repaired Fault on) ? Thanks Sachi

Vulpes · Answer

If you wanted to get the text of all fault node attributes (regardless of category) then the query would be: var query = from element in auto.Elements() where element.Name == fault select element; fault = (from element in query select element.Element(text).Value).ToArray(); Your 'autocomplete' query should then work the same as it does now.

sachi vasishta · Answer

Thanks a lot Vulpes. I need a small help on this. Actually I have a Ajax autocomplete extender textbox. Currently I have a values hardcoded in a string array like below. string[] arrReturn = null; static string[] fault = { Pending Fault found on Repaired Fault on }; and the below Linq query inside the web service method to return the string array arrReturn = (from m in fault where m.StartsWith(prefixText StringComparison.CurrentCultureIgnoreCase) select m).Take(count).ToArray(); so If I type p/P in the textbox its autocompletes to  Pending Fault found on and if I type r/R it autocompletes to Repaired Fault on. Now I want to achieve the same using the XML file I have created instead of reading from the hardcoded string array. Thanks Sachi

Jean Paul · Answer

You can use XMLDocument or LINQ2XML to do the job. XElement xElement = XElement.Load(@c:\temp\xml.txt); var list = (from e in xElement.Elements(fault) where e.Attribute(category).Value == pending select e).ToList(); foreach (XElement xe in list) Console.WriteLine(xe.Value); Console.ReadKey(false);

Vulpes · Answer

You should be able to do it using LINQ to XML as follows: using System; using System.Linq; using System.Xml.Linq; class Program { static void Main() { XElement auto = XElement.Load(Auto.xml); var query = from element in auto.Elements() where element.Name == fault && element.Attribute(category).Value == pending select element; string[] pendingValues = (from element in query select element.Element(text).Value).ToArray(); foreach(string s in pendingValues) Console.WriteLine(s); Console.ReadKey(); } }