Reading XML Node

[rbondalapati]

Hi I am trying to read xmlNode and validate user
code used to do this is given below.

i am able to load the XMLDocument.
but the SelectSingleNode method call is always returning null value.

is there anything wrong in this code.

ProcessLogin(string userName, string password)
{
        HttpServerUtility Server = HttpContext.Current.Server;
        HttpRequest Request = HttpContext.Current.Request;
 
        XmlDocument doc = new XmlDocument();
        string path = Server.MapPath("/DataFile.xml");
        doc.Load(path);
        XmlNode node = doc.SelectSingleNode("Data/Users/UserName[. = '" + userName + "']/parent::node()/Password");
        if (node != null && node.InnerText == password)
            return true;
        else
            return false;
}

and the xml document is as follows

<?xml version="1.0" encoding="utf-8" ?>
<Data xmlns="http://tempuri.org/DataFile.xsd">
    <Users>
        <UserName>Usr1</UserName>
        <Password>123456</Password>
        <Active>true</Active>
        <UpdatedTime>1/1/2007</UpdatedTime>
    </Users>
    <Users>
        <UserName>su234</UserName>
        <Password>su432</Password>
        <Active>true</Active>
        <UpdatedTime>1/1/2007</UpdatedTime>
    </Users>
    <Users>
        <UserName>admin</UserName>
        <Password>sec123</Password>
        <Active>true</Active>
        <UpdatedTime>1/1/2007</UpdatedTime>
    </Users>
    <Style>
        <Font>Arialasda</Font>
        <FontSize>12</FontSize>
        <ForeColor>Blue</ForeColor>
        <BackColor>White</BackColor>
        <BackGroundImage></BackGroundImage>
        <BulletIcon>Next.gif</BulletIcon>
        <Speed>1</Speed>
        <UpdatedTime>1/1/2007</UpdatedTime>
    </Style>
</Data>

[dorinbogdan]

Try to get the password node like:

     XmlNode node = doc.SelectSingleNode("Data/Users[UserName = '" + userName + "'].ParentNode.SelectSingleNode("Password");
 
 

[dorinbogdan]

Hi,
Did you succeed to solve the problem ?
If yes, please let me know, in order to close the thread.
Thanks,
Dorin.