parse web service xml response in c# to get specific node value in variables

Question

using System;
using System.Xml;
using SampleWebserviceApp.net.myasp.deepakgaur;
namespace SampleWebserviceApp
{
 class Program
 {
    static void Main(string[] args)
    {
        InventoryWebservice Webservice = new InventoryWebservice();
        var value = Webservice.GetDataByID("1");
        XmlDocument doc = new XmlDocument();
        doc.LoadXml(value);
        string id = doc.GetElementsByTagName("Id").ToString();
        Console.WriteLine(value);
        Console.WriteLine(id);
        Console.ReadKey();
       }
    }
}

can anyone help me out how can i get node vaue from my web service response

<NewDataSet>
  <Table>
    <Id>1         </Id>
    <ProductName>Hp Laptop</ProductName>
    <SerialNumber>abc111    </SerialNumber>
    <Status>Delivered           </Status>
    <CustomerName>Shatakshi</CustomerName>
  </Table>
</NewDataSet>

what i am trying to do is get id , productname, serial number, status , cusomername value in respective varialble
plaese help me understand how can i achive this.

What code did you try?

BugFinder
– BugFinder

2015-08-04 07:08:09 +00:00
Commented Aug 4, 2015 at 7:08 — BugFinder
– BugFinder, Commented Aug 4, 2015 at 7:08

Han · Accepted Answer · 2015-08-04 08:00:34Z

Use Linq to XML. Please note that I don't have the web service InventoryWebservice, so I just create an xml document manually.

using System;
using System.IO;
using System.Linq;
using System.Xml.Linq;

class Program
{
    static void Main()
    {
        // create an XML document manually
        var doc = XDocument.Load(new StringReader(@"<NewDataSet>
  <Table>
    <Id>1         </Id>
    <ProductName>Hp Laptop</ProductName>
    <SerialNumber>abc111    </SerialNumber>
    <Status>Delivered           </Status>
    <CustomerName>Shatakshi</CustomerName>
  </Table>
</NewDataSet>"));

        // query the XML document
        var product = doc
            .Descendants("Table")
            .Select(x => new {
                        Id = x.Element("Id").Value,
                        ProductName = x.Element("ProductName").Value,
                        SerialNumber = x.Element("SerialNumber").Value,
                        Status = x.Element("Status").Value,
                        CustomerName = x.Element("CustomerName").Value
                        })
            .FirstOrDefault();

        // print the result
        if (product != null)
        {
            Console.WriteLine("Id = {0}", product.Id);
            Console.WriteLine("Product Name = {0}", product.ProductName);
            Console.WriteLine("Serial Number = {0}", product.SerialNumber);
            Console.WriteLine("Status = {0}", product.Status);
            Console.WriteLine("Customer Name = {0}", product.CustomerName);
        }

        Console.Write("Press any key to continue . . . ");
        Console.ReadKey(true);
    }
}

Thanks Handoko Chen it works just fine, really appreciate your fast response thanks again

Collectives™ on Stack Overflow

parse web service xml response in c# to get specific node value in variables

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related