traverse xml document nodes - SelectNodes()

[Stephen]

I have the following code that uses xquery to return search results
from an xml doc.

dim xmlString as string

xmlString =
"siteMapNod e/siteMapNode/siteMapNode/siteMapNode[contains(transl ate(@title,'abc defghijklmnopqr stuvwxyz','ABCD EFGHIJKLMNOPQRS TUVWXYZ'),
'" + txtSearchCriter ia.Text.ToUpper () + "')]"
nodeList=root.S electNodes(xmlS tring,nsmgr)
It all works great as long as I specify the level in which to search:

siteMapNode/siteMapNode/siteMapNode/siteMapNode

but I want to search all levels of the doc.

siteMapNode
siteMapNode/siteMapNode
siteMapNode/siteMapNode/siteMapNode

etc..

will I have to loop for each level and append the nodes:

dim myNode as string
dim myNodeLevel as string
do while something
myNodeLevel = myNodeLevel & "/siteMapNode"
loop

xmlString =
myNodeLevel &
"[contains(transl ate(@title,'abc defghijklmnopqr stuvwxyz','ABCD EFGHIJKLMNOPQRS TUVWXYZ'),
'" + txtSearchCriter ia.Text.ToUpper () + "')]"
nodeList=root.S electNodes(xmlS tring,nsmgr)

anyway, that is air code but hopefully you'll get my point. Any help
is appreciated.

[Stephen]

I did figure something out. Here is what I did:

dim doc as XmlDocument = new XmlDocument()
doc.Load(Server .MapPath("web.s itemap"))

dim nodeList as XmlNodeList
dim root as XmlNode = doc.DocumentEle ment

dim nsmgr as XmlNamespaceMan ager = new
XmlNamespaceMan ager(doc.NameTa ble)
nsmgr.AddNamesp ace("ns0",
"xmlns:ns0='urn :schemas-microsoft-com:xslt")

dim nodeLevel as string = ""
dim i as integer
for i = 1 to 4
nodeLevel = nodeLevel & "siteMapNod e/"
dim xmlString as string = nodeLevel &
"siteMapNod e[contains(transl ate(@title,'abc defghijklmnopqr stuvwxyz','ABCD EFGHIJKLMNOPQRS TUVWXYZ'),
'" + txtSearchCriter ia.Text.ToUpper () + "')]"
'dim xmlString as string =
"siteMapNod e/siteMapNode/siteMapNode/siteMapNode[contains(transl ate(@title,'abc defghijklmnopqr stuvwxyz','ABCD EFGHIJKLMNOPQRS TUVWXYZ'),
'" + txtSearchCriter ia.Text.ToUpper () + "')]"
nodeList=root.S electNodes(xmlS tring,nsmgr)
'Change the price on the books.
dim book as XmlNode
for each book in nodeList
Dim tempRow As New TableRow()
Dim tempCell As New TableCell()
tempCell.Text = "<a class='HoverSty le' href=" &
book.Attributes ("url").Valu e & " target='_blank' a>" &
book.Attributes ("title").Va lue & "</a>"
tempRow.Cells.A dd(tempCell)
tblSearchResult s.Rows.Add(temp Row)
next
next i

It loops four levels of the xml doc. Although I would like to be able
to determone the number of levels without hard-coding. I will have to
research this.

[Martin Honnen]

Stephen wrote:

It all works great as long as I specify the level in which to search:

siteMapNode/siteMapNode/siteMapNode/siteMapNode

but I want to search all levels of the doc.

siteMapNode
siteMapNode/siteMapNode
siteMapNode/siteMapNode/siteMapNode

Then you need the XPath expression
//siteMapNode
to search from the document root node or
.//siteMapNode
to search from the context node.
--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[Stephen]

Very nice. Worked perfectly. I can get rid of the loop now. Thanks