XPath Syntax question

[chadau]

I want to get the node with username = test1. What is the xpath syntax to use in order to do this?

<UserAccounts xmlns=&quot;

http://tempuri.org/UserAccounts.xsd&quot;>

<User>
<UserName>Test</UserName>
<Password>pass99</Password>
<AccountHolder>
</AccountHolder>
<Address>
</Address>
<City>
</City>
<State>
</State>
<Zip>
</Zip>
<Role>
</Role>
</User>
<User>
<UserName>Test2</UserName>
<Password>pass98</Password>
<AccountHolder>
</AccountHolder>
<Address>
</Address>
<City>
</City>
<State>
</State>
<Zip>
</Zip>
<Role>
</Role>
</User>
</UserAccounts>

 

[palbano]

Well first you have to have a <UserName> element containing the text 'test1&quot;, then this would work

//UserName[text() = 'test1']

-pete

 

[chadau]

That should return the node? It doesn't seem to be working for me. Any other suggestions?

 

[palbano]

>> Any other suggestions?

As far as i know that's the only way. What environment and parser are you using?

-pete

 

[chadau]

MSXML 4.0

 

[palbano]

That's what i tested with so i have no idea why it does not work for you. Posting some code might help.

-pete

 

[chadau]

This is what I have; code from a Global.asax file in an ASP.Net application:

Sub Application_AuthenticateRequest(ByVal sender As Object, ByVal e As EventArgs)
' Fires upon attempting to authenticate the use
Dim strUserName As String
Dim objRoles As XmlDocument
Dim strRoles As String()
Dim objNode As XmlNode
Dim strXPath As String

objRoles = GetRoles()

If Context.Request.IsAuthenticated Then
strUserName = Context.User.Identity.Name
strXPath = &quot;UserName[text() = '&quot; & strUserName & &quot;']&quot;
objNode = objRoles.DocumentElement.SelectSingleNode(strXPath)

*****Above: objNode gets set to nothing****

If Not IsNothing(objNode) Then
strRoles(0) = objNode.FirstChild(&quot;Role&quot.Value
Context.User = New GenericPrincipal(Context.User.Identity, strRoles)
End If
End If
End Sub

Function GetRoles() As XmlDocument
Dim objRoles As XmlDocument

objRoles = Context.Cache(&quot;Roles&quot
If objRoles Is Nothing Then
objRoles = New XmlDocument()
objRoles.Load(Server.MapPath(&quot;UserAccounts/UserAccounts.xml&quot)
Context.Cache.Insert(&quot;Roles&quot;, objRoles, New Caching.CacheDependency(Server.MapPath(&quot;UserAccounts/UserAccounts.xml&quot))
End If

Return objRoles
End Function

 

[palbano]

>> &quot;UserName[text() = '&quot; & strUserName & &quot;']&quot;

>> [red]//[/red]UserName[text() = 'test1']


-pete