To search specific Items in a XML file using C# asp.net

Question

0.00/5 (No votes)

See more:

XML

<profile type="ptPerson">
  <people>
    <person>
      <domain>http://www.peoplefinders.com</domain>
      <id>5397080</id>
      <name>
        <title></title>
        <firstName>ABRAHAM</firstName>
        <middleName></middleName>
        <lastName>CHARLOTTEAA</lastName>
        <fullName>ABRAHAM CHARLOTTEAA</fullName>
      </name>
      <age>95</age>
      <dob>AV</dob>
      <address>AV</address>
      <phone>855-241-0552</phone>
      <business></business>
      <link>order.asp?1=ABRAHAM;;;;CHARLOTTEAA;;;;;;;;;;;;;;;;;;5397080&amp;2=name&amp;3=people&amp;4=14&amp;5=Abraham;;;;Aaron;;;;;;;;;;;;&amp;from=dcwTest</link>
      <email></email>
      <akas>
        <name>
          <title></title>
          <firstName>ABRAHAM</firstName>
          <middleName></middleName>
          <lastName>AARON</lastName>
          <fullName>ABRAHAM AARON</fullName>
        </name>
      </akas>
      <cities>
        <locale>
          <city>Pompano Beach</city>
          <state>FL</state>
        </locale>
      </cities>
      <relatives>
        <relative>
          <name>
            <title></title>
            <firstName>CHARLOTTE</firstName>
            <middleName>W</middleName>
            <lastName>AARON</lastName>
            <fullName>CHARLOTTE W AARON</fullName>
          </name>
          <id>5397088</id>
          <link>order.asp?1=CHARLOTTE;;W;;AARON;;;;;;;;;;;;;;;;;;5397088&amp;2=name&amp;3=people&amp;4=1&amp;5=Abraham;;;;Aaron;;;;;;;;;;;;&amp;from=dcwTest</link>
        </relative>
      </relatives>
      <key>ABRAHAM CHARLOTTEAA</key>
      <source>dsPeopleFinders</source>
      <itemType>itPerson</itemType>
    </person>
</people>

I want to search for full details of specific persons in this xml file whose first name and last name are passed from textboxes on the webform.
i.e on Form1--> textbox1--> firstname
textbox2 -- > lastname
textbox3--> city
now on the result page...i get these values as querystring.... and based on these values i have to search values from the xml file and display them in the gridview.
pls guide...
Thanks....
vikas

Posted 28-Mar-11 18:05pm

Vikas1546

Updated 28-Mar-11 18:29pm

Prerak Patel

v2

Add a Solution

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)

m@dhu · Answer 1 · 2011-03-28T18:58:00

Solution 1

MSIL

public void fillfromXML(string Code)
        {
            XmlDocument doc = new XmlDocument();
            doc.Load(Server.MapPath(@"XMLFile1.xml"));
            XmlNodeList addlst = doc.SelectNodes("people/person/name/firstName");
            foreach (XmlNode Empcode in addlst)
            {
                //pass textbox value for Code
                if (Empcode.InnerText == Code)
                {
                    //code to get the values and display in gridview.
                }
            }
        }

Posted 28-Mar-11 18:58pm

m@dhu

Comments

Vikas1546 29-Mar-11 1:03am

@mkgoud
...Thanks buddy for ur timely help... but can u pls eloborate...
... can u pls give more code snippets for doing this..
..Thanks..

Vikas1546 29-Mar-11 1:06am

i.e how to fill a datatable or dataset using this..to bind with the gridview

m@dhu 29-Mar-11 1:09am

Check the link
http://www.developer.com/net/asp/article.php/3553881/Binding-to-XML-Data-in-ASPNET-20.htm

Veeraiahkatteboina 1-Feb-13 1:56am

hai