retrieving xml value

[Guest]

below is my xml structure, how can I use Xquery to query for a specific
username?

<?xml version="1.0" encoding="utf-8" ?>
<users>
<user>
<username></username>
<pwd></pwd>
</user>
</users>

 

[Guest]

Your XML:

<?xml version="1.0" encoding="utf-8" ?>
<users>
<user>
<username>John</username>
<pwd></pwd>
</user>
<user>
<username>Steve</username>
<pwd></pwd>
</user>
<user>
<username>Kate</username>
<pwd></pwd>
</user>
</users>


And you code

XPathDocument xpd = new XPathDocument(Server.MapPath(@"~/user.xml"));
XPathNavigator xpn = xpd.CreateNavigator();
XPathNodeIterator i = xpn.Select(@"//username");
while (i.MoveNext())
Response.Write(i.Current.Value);