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.