Fetching Complex XML Data Through C#

In this blog you will learn how to fetch Complex XML Data Through C#.

Introduction

 

XML stands for eXtensible Markup Language, very  similar to HTML. It is a standard flexible way of creating information formats and electronically sharing that structured data via the public Internet as well as via Corporate Networks.

 

Here I will be using a simple MVC Project to work with complex XML structure or hierarchical XML.

 

Step 1

 

Open solution and add an .xml file which contains nested details of phones like  Samsung, Apple, Vivo .

 

File Name - PhoneDetails.xml

<?xml version="1.0" encoding="utf-8" ?>
<root>
<Phone>
   <product_name>Samsung Phone</product_name>
   <price_range>15000-30000</price_range>
   <service_centre>
      <streetnames>
         <street1>StreetA</street1>
         <street2>StreetB</street2>
      </streetnames>
      <city>Kolkata</city>
      <pin>700001</pin>
   </service_centre>
</Phone>
<Phone>
   <product_name>Apple Phone</product_name>
   <price_range>30000-50000</price_range>
   <service_centre>
      <streetnames>
         <street1>StreetC</street1>
         <street2>StreetD</street2>
      </streetnames>
      <city>Kolkata</city>
      <pin>700002</pin>
   </service_centre>
</Phone>
<Phone>
   <product_name>Vivo Phone</product_name>
   <price_range>15000-25000</price_range>
   <service_centre>
      <streetnames>
         <street1>StreetE</street1>
         <street2>StreetF</street2>
      </streetnames>
      <city>Kolkata</city>
      <pin>700003</pin>
   </service_centre>
</Phone>
</root>

Step 2

 

Add class PhoneModelunder Models Folder and implement the following code:

namespace WebApplication1.Models {
    public class PhoneModel {
        public string ProductName {
            get;
            set;
        }
        public string PriceRange {
            get;
            set;
        }
        public string Street1 {
            get;
            set;
        }
        public string Street2 {
            get;
            set;
        }
        public string City {
            get;
            set;
        }
        public string Pin {
            get;
            set;
        }
        public PhoneModel() {}
        public PhoneModel(string productname, string pricerange, string street1, string street2, string city, string pin) {
            this.ProductName = productname;
            this.PriceRange = pricerange;
            this.Street1 = street1;
            this.Street2 = street2;
            this.City = city;
            this.Pin = pin;
        }
    }
}

Step 3

 

Now go to the Controller to add the below code:

using System.Collections.Generic;
using System.Web.Mvc;
using System.Xml;
using WebApplication1.Models;
namespace WebApplication1.Controllers {
        public class HomeController: Controller {
                public ActionResult PhoneInfo() {
                    List < PhoneModel > phoneList = new List < PhoneModel > ();
                    PhoneModel phones_detail = new PhoneModel();  //You could use any of the two constructor.
                    XmlDocument xdoc = new XmlDocument();
                    //Path of your .xml file
                    xdoc.Load(Server.MapPath("~/PhoneDetails.xml"));
                    XmlNodeList phones = xdoc.SelectNodes("root/Phone");
                    //Parent ForEacloop
                    foreach(XmlNode phone in phones) {
                        phones_detail.ProductName = phone["product_name"].InnerText.Trim();
                        phones_detail.PriceRange = phone["price_range"].InnerText.Trim();
                        XmlNodeList streetnames = phone.SelectNodes("service_centre/streetnames");
                        //Nested ForEach Loop
                        foreach(XmlNode streetname in streetnames) {
                            phones_detail.Street1 = streetname["street1"].InnerText.Trim();
                            phones_detail.Street2 = streetname["street2"].InnerText.Trim();
                        }
                        phones_detail.City = streetnames[0].NextSibling.InnerText;
                        phones_detail.Pin = streetnames[0].NextSibling.NextSibling.InnerText;
                        //Adding to the List
                        phoneList.Add(new PhoneModel(phones_detail.ProductName, phones_detail.PriceRange, phones_detail.Street1, phones_detail.Street2, phones_detail.City, phones_detail.Pin));
                    }
                    return View(phoneList);
                }

Step 4

 

Once finished with all three above steps eventually add a ViewPage to see the output .

 

Right click on the controller and select add View .

 

Note

Select "List" as Template Option and the Model class will be the class which is added in Step 2.

 

Click on add button which creates the template for us. Another approach could be selecting the Empty Template and adding the following html code manually.

@model IEnumerable
<WebApplication1.Models.PhoneModel>
    <table class="table">
        <tr>
            <th>
@Html.DisplayNameFor(model => model.ProductName)
</th>
            <th>
@Html.DisplayNameFor(model => model.PriceRange)
</th>
            <th>
@Html.DisplayNameFor(model => model.Street1)
</th>
            <th>
@Html.DisplayNameFor(model => model.Street2)
</th>
            <th>
@Html.DisplayNameFor(model => model.City)
</th>
            <th>
@Html.DisplayNameFor(model => model.Pin)
</th>
            <th></th>
        </tr>
@foreach (var item in Model) {

        <tr>
            <td>
@Html.DisplayFor(modelItem => item.ProductName)
</td>
            <td>
@Html.DisplayFor(modelItem => item.PriceRange)
</td>
            <td>
@Html.DisplayFor(modelItem => item.Street1)
</td>
            <td>
@Html.DisplayFor(modelItem => item.Street2)
</td>
            <td>
@Html.DisplayFor(modelItem => item.City)
</td>
            <td>
@Html.DisplayFor(modelItem => item.Pin)
</td>
        </tr>
}

    </table>

Execute the program

 

Happy Learning...