SEARCH XML ATTRIBUTE BASED ON THE VALUE OF ANOTHER ATTRIBUTE

[ATLANTA PATNAIK via DotNetMonster.com]

<ITPL>
-<GATE NAME="2">
<SLOT SNO="5" TYPE="2" STATUS="VACANT">
<SLOT SNO="6" TYPE="2" STATUS="VACANT">
<SLOT SNO="7" TYPE="4" STATUS="VACANT"><VEHICLE VNO="5" TYPE="2"
MODEL="BOLERO" />
<SLOT SNO="8" TYPE="2" STATUS="VACANT">
</GATE>
</ITPL>

For the above file how can i query the slot sno for vmodel="Bolero"?

 

[Brian Scott]

You should look at using XPath or XQuery,

You can learn all about it at the following addresses;

http://www.w3schools.com/xquery/default.asp
http://www.w3schools.com/xpath/default.asp

These methods allow you to query and traverse xml data in an xmldocument. I
think this will provide you with everything you need to do.

An example of querying an xml document would be the following using XQuery
"doc("books.xml")/bookstore/book[price<30]""ATLANTA PATNAIK via

 

[Jon Skeet [C# MVP]]

<ITPL>
-<GATE NAME="2">
<SLOT SNO="5" TYPE="2" STATUS="VACANT">
<SLOT SNO="6" TYPE="2" STATUS="VACANT">
<SLOT SNO="7" TYPE="4" STATUS="VACANT"><VEHICLE VNO="5" TYPE="2"
MODEL="BOLERO" />
<SLOT SNO="8" TYPE="2" STATUS="VACANT">
</GATE>
</ITPL>

For the above file how can i query the slot sno for vmodel="Bolero"?

By looking at the XPath query I gave you before, reading the
documentation for XPath, and adapting it appropriately.