Get corresponding node in Xml

Question

I have two child node in a parent tanmay 1234567890 I want to get the contact node where corresponding name is provided. please help me I am just starting xml. Thank you in advance.

Damodar · Answer

here is the file. I think this is what you need. There has been a small looping problem in the earlier mentioned program. I corrected it now. Please see the file. Please mark as answer if you are satisfied.

Sam Hobbs · Answer

If you want to use SQL then use a database class such as DataTable; I don't see SQL being used in any of the other suggestions here. There are many ways to do many things and many times the first suggestion is not always the best for you.

Tanmay Sarkar · Answer

Yes i get it now ... Thank you sir :)

Sam Hobbs · Answer

To search for articles go to the web site home page; don't use the forum's search to search for articles. If you search for XmlSerializer from the web site's home page you will find my article.

Tanmay Sarkar · Answer

Sir can you put here your article link please.. i want to read it... but i am not getting it ... may be my search tag is wrong. Please put here sir your article link. specially want to learn XmlSerializer . Thank you sir. I am waiting.....

Sam Hobbs · Answer

If you are not familiar with the DataTable . ReadXml Method then look at it. Also if you are not familiar with the XmlSerializer Class then look at my article in this web site about the XmlSerializer Class ; it does not use SQL but it is worth knowing about.

Tanmay Sarkar · Answer

yes sir you right i need more ... first i must read few books deeply.. you take my point what i am want perfectly .... Thank you sir :)

Tanmay Sarkar · Answer

Damodar thanks for your support. Your code is good but showing all contact number of another member of .xml  because when it is completed you can't set rtnval = N; so the code will be like if (pdata.Name == contact) { MessageBox.Show(contact no :  + pdata.InnerText); rtnval = N; } it's work fine now. Thank you so much! :)

Tanmay Sarkar · Answer

Sir I just want to learn how handle a simple search according where clause in sql. like:- ..... where name 'tanmay' there will be two text field one will provide name by user & click button & another field will show the contact. That's my basic thing. And when I starting sql it was also my basic program on that time. Thank you! :)

Sam Hobbs · Answer

Do you neeed to do this one time per execution or many times per execution? If many times (many names) then there are more efficient ways.

Tanmay Sarkar · Answer

Thanks but it still not showing any thing.. may be it's my mistake to implement it. I write as you say... private void button1_Click(object sender EventArgs e) { XmlDocument xmldoc = new XmlDocument(); xmldoc.Load(test.xml); XmlNode node = xmldoc.DocumentElement; foreach (XmlNode phonelist in node.ChildNodes) { foreach (XmlNode pbdat in phonelist.ChildNodes) { if (pbdat.InnerText == Tanmay) { if (pbdat.Name == contact) { string contactno = pbdat.InnerText; MessageBox.Show(contactno); } } } } } If you have a little bit time can you please upload your cs file. Thank you in advance.

Damodar · Answer

you have to write two foreach loops. One to go into the phonelist and then to the pbdata. foreach( XmlNode phonelist in node.ChildNodes) { foreach (XmlNode pbdat in phonelist.ChildNodes) { if (pbdat.InnerText == tanmay) { if(pbdat.Name == contact) { string contactno = InfoNode.Innertext; // this gives you the contact no when the name is given. } } } you told u only had one Information parent node. so i wrote only one foreach loop. Try this it should work now.

Tanmay Sarkar · Answer

It's through an exception in string contactno = InfoNode.Innertext; So i change it to string contactno = InfoNode.InnerText.ToString(); but it not showing any thing! Is i have a mistake? My xml file is as follows. Tanmay 1324569780 help please..

Damodar · Answer

Hey Tanmay XmlDocument xmldoc = new XmlDocument(); xmldoc.Load (File); XmlNode node = xmldoc.DocumentElement; foreach (XmlNode InfoNode in node.ChildNodes) { if (InfoNode.InnerText == tanmay) { if(InfoNode.Name == contact) { string contactno = InfoNode.Innertext; // this gives you the contact no when the name is given. } } } use this .. may be this will help you.