Making XML Search All The File? How Always looks at the first one. (Still Needed)

Question

0.00/5 (No votes)

See more:

Basically i have a piece of code which i created, which is a if loop (selection) and i want it to search a XML file for what has been entered in the textboxes, but it only searches the first node and then either declares it maches or not. How do i make it please search the whole file and look for matches and not the first node. Below is the code i have at the moment.

C#

if (UsernameTextbox.Text == UsernamenodeVariable && PasswordTextbox.Text == PasswordnodeVariable && PermissionComboBox.SelectedItem.ToString() == PermissionnodeVariable)
{

    MessageBox.Show("Login Details Match");
    Menu MenuPage = new Menu();
    MenuPage.Show();
    this.Hide();
}

Any suggestions please for this. Would be greatful

Posted 8-Dec-13 2:53am

Member 9665875

Updated 9-Dec-13 5:58am

v4

Add a Solution

Comments

Mahesh Bailwal 8-Dec-13 9:57am

can you share sample XML file and example of what you want to search in that.

Member 9665875 8-Dec-13 11:22am

XmlNode Usernamenode = xdoc.SelectSingleNode("Users/User/Username");
string UsernamenodeVariable = Usernamenode.InnerText;

XmlNode Passwordnode = xdoc.SelectSingleNode("Users/User/Password");
string PasswordnodeVariable = Passwordnode.InnerText;

XmlNode Permissionnode = xdoc.SelectSingleNode("Users/User/Permission");
string PermissionnodeVariable = Permissionnode.InnerText;

Richard MacCutchan 8-Dec-13 12:37pm

You should use your debugger to check the actual values of each variable at the time of the if statement, to determine why it always matches.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 7722275 · Accepted Answer · 2013-12-08T09:26:00

Hi.

The reason it searches only the first node is because you need to specify in which node to search. Currently you only specify the upper most node sets with

xdoc.SelectSingleNode("Users/User/Password");

to search for subnodes, you need to use

subnode.SelectSingleNode("Users/User/Password");

If you know the names of the nodes, this becomes easy. If you don't, this becomes a bit more tricky. I have a recursive method and an override for it that could help you. It's not the most elegant code there is but it does solve your problem.

C#

private XmlNode checkNode(XmlDocument xdoc, string nodeName)
{
   XmlNode node;
   if(xdoc.SelectSingleNode(nodeName) != null)
   {
      node = xdoc.SelectSingleNode(nodeName);
   }
   else
   {
      foreach(XmlNode currentNode in xdoc.DocumentElement.ChildNodes)
      {
         node = checkNode(currentNode, nodeName);
         if(node != null)
         {
             break;
         }
      }
   }
   return node;
}

private XmlNode checkNode(XmlNode parentNode, string nodeName)
{
   XmlNode node;
   if(currentNode.SelectSingleNode(nodeName) != null)
   {
      node = xdoc.SelectSingleNode(nodeName);
   }
   else
   {
      foreach(XmlNode currentNode in parentNode.DocumentElement.ChildNodes)
      {
         node = checkNode(currentNode, nodeName);
         if(node != null)
         {
             break;
         }
      }
   }
   return node;
}

Here is how you would do the check (Example):

//So it's easier to read
string username = UsernameTextbox.Text;
string password = PasswordTextbox.Text;
string permission = PermissionComboBox.SelectedItem.ToString();

if (username == checkNode(xdoc, "usernameNodeName").InnerText
    && password == checkNode(xdoc, "passwordNodeName").InnerText
    && permission == checkNode(xdoc, "permissionNodeName").InnerText)
{
   MessageBox.Show("Login Details Match");
   Menu MenuPage = new Menu();
   MenuPage.Show();
   this.Hide();
}