How to read XMl file using Xpath

**ujjwal** · Mar 15, 2011 01:11

Hi all,
I have to read a XML using Xpath in Visual Studio .Net 1.1 using c#.
But couldn't do it.
Can anyone help me.?
i am stuck with my code.
The XMl file is as follows:

Code:

<?xml version="1.0" encoding="UTF-8" ?> 
 <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
 <ERRORCODE>0</ERRORCODE> 
 <PRODUCT BUILD="02-10-2004" NAME="AutoSpec2" VERSION="7.0v1" /> 
 <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="AutoSpec2d.USR" RECORDS="4" TIMEFORMAT="h:mm:ss a" /> 
 <METADATA>
 <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="File_Name" TYPE="TEXT" /> 
 <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Description" TYPE="TEXT" /> 
 <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Purpose" TYPE="TEXT" /> 
 <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Parent" TYPE="TEXT" /> 
 <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Type" TYPE="TEXT" /> 
 <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Classification" TYPE="TEXT" /> 
 <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Status" TYPE="TEXT" /> 
 <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Category" TYPE="TEXT" /> 
 
 </METADATA>
 <RESULTSET FOUND="4">
 <ROW MODID="7" RECORDID="1498">
 <COL>
 <DATA>P1_U02_C01_001P_RD10</DATA> 
 </COL>
 <COL>
 <DATA>Size:Full Students painting fence</DATA> 
 </COL>
 <COL>
 <DATA>To show teamwork</DATA> 
 </COL>
 <COL>
 <DATA>Parent code need to be mentioned here</DATA> 
 </COL>
 <COL>
 <DATA>Spec type (Art or Photo)</DATA> 
 </COL>
 <COL>
 <DATA>Classification should mentioned here( for example "New", "PU","2ndU" etc) </DATA> 
 </COL>
 <COL>
 <DATA>Status need to mention here (for ex : Created, Release,Approved etc)</DATA> 
 </COL>
 <COL>
 <DATA>category (For example "RESEARCH","TECH" etc)</DATA> 
 </COL>
 </ROW>
 </RESULTSET>
 </FMPXMLRESULT>

Please help me.

**ujjwal** · Mar 15, 2011 03:43

Thanks.
I have writen it.
my code is as follows:

Code:

/******* Working on XML Reading ********/

					XPathDocument doc = new XPathDocument(Server.MapPath("~/Uploaded_File/" + fileName));
					XPathNavigator nav = doc.CreateNavigator();	
					XmlNamespaceManager nsmgr = new XmlNamespaceManager(nav.NameTable);
					nsmgr.AddNamespace("S", "http://www.filemaker.com/fmpxmlresult");

					XPathExpression expr = nav.Compile("S:FMPXMLRESULT//S:ROW");
					expr.SetContext(nsmgr);
					XPathNodeIterator rows = nav.Select(expr);

					XPathExpression exprIn = nav.Compile("//S:COL");
					exprIn.SetContext(nsmgr);
					while (rows.MoveNext())
					{
						XPathNodeIterator cols = rows.Current.Select(exprIn);
						string MODID = rows.Current.GetAttribute("MODID", "");	
						XPathExpression exprFinal = nav.Compile("S:DATA");
						exprFinal.SetContext(nsmgr);
						while (cols.MoveNext())
						{	
									string DATA =GetInnerXml(cols.Current.Select(exprFinal).Current);
						} 					             
					}