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

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?

1 Reply

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

Vulpes12y ago
Accepted 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" />

"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