to get child elements OF AN XML USING C#LINQ XML

Question

I have the xml structure like this.. TABLE NAME = PDF  PRIMARYKEYE = PDF  > FIELD NAME = PNUMBER FIELD = FieldTypeNumber / > FIELD NAME = STATUS FIELDTYPE = FieldTypeNumber / > FIELD NAME = COMPANY FIELDTYPE = FieldTypeNumber / > FORM NAME = PDF_DOC TITLE = REGEN_PDF_DOC > FORMFIELD NAME = POLICY_NUMBER DBCOLUMNNAME = (SLECT POLICY_NUMBER FROM POLICY NOTE WHERE POLICY.POLICY=NOTE.TABLE_KEY) / > FORMFIELD NAME = STATUS DBCOLUMNNAME = (SELECT STATUS FROM STATUS_VALUE) / > FORMFIELD NAME = COMPANY DBCOLUMNNAME = (SELECT COMPANY FROM COMPANY WHERE COMPANY=20000) / > FORMFIELD NAME = ENTERPRISE / > FORMFIELD NAME = EFFECTIVE_DATE / > / FORM > SEARCH NAME = SEARCHPDF ORDERBYCLAUSE = PDF  > JOIN TABLE = NOTATION TYPE = LEFT ON = PDF CONDITION= ISNOTNULL / > JOIN TABLE = PNUM TYPE = INNER ON = NOTE= POLICY CONDITION = ISNOTNULL / > SEARCHFIELD NAME = PNUMBER LABEL = PNUMBER / > SEARCHFIELD NAME = EFFECTIVE_DATE LABEL = EFFECTIVE DATE / > / SEARCH > / TABLE > Im trying to list out the elements with the name JOIN using the below syntax.but ending up with null values..can somebody fix this? The source file filename.xml is loaded as xdocument and i ahve used LINQ to achioeve this using XELEMENT. XElement table = this.filename.Root.Elements(TABLE).Single(W => W.Attribute(NAME).Value.Equals(PDF )); Now im trying to list out the elements with the element nae as JOIN with the below syntax; IEnumerable joins = table.Element(SEARCH).Elements(JOIN); but even after execution  the variable joins still has null value instead of 2 join elements . Can someone look into this?

Vulpes · Answer

I had to make a couple of changes to the XML file to get it to compile which now looks like this: FIELDTYPE =FieldTypeNumber /> Y NOTE WHERE POLICY.POLICY=NOTE.TABLE_KEY) /> OMPANY=20000) /> PDF CONDITION=ISNOTNULL /> Subect to that the following code is working OK: var joins = from xe in table.Element(SEARCH).Elements(JOIN) select xe; foreach(XElement join in joins) { foreach(XAttribute xa in join.Attributes()) { Console.WriteLine({0} = {1} xa.Name xa.Value); } Console.WriteLine(); } and produces the following output: TABLE = NOTATION TYPE = LEFT ON = PDF CONDITION = ISNOTNULL TABLE = PNUM TYPE = INNER ON = NOTE= POLICY CONDITION = ISNOTNULL

to get child elements OF AN XML USING C#,LINQ ,XML