Parse/Read XML Having Nested Nodes To Display As A List In ASP.NET MVC

Step 6

Now, let's come to the actual implementation of UsersController. Create an action method called Upload() of request type POST.

1. Make sure to include the below namespaces.
   
   1. using System.Xml;
   2. using Xml_MVC.Models; (Xml_MVC - > project where the models are present)

2. Create a list type Model Oobject and go for parsing as below.
   
   1. List<UsersModel> userList = new List<UsersModel>();
   2. var file = Request.Files[0];
   3. if (file != null && file.ContentLength > 0)
   4. {
   5. XmlDocument xmldoc = new XmlDocument();
   6. xmldoc.Load(file.InputStream);
   7. UsersModel user;
   8. XmlNodeList usernodes = xmldoc.SelectNodes("Users/user");
   9. foreach (XmlNode usr in usernodes)
   10. {
   11. user = new UsersModel();
   12. user.Id = Convert.ToInt32(usr["id"].InnerText);
   13. user.Name = usr["name"].InnerText;
   14. user.Gender = usr["gender"].InnerText;
   15. user.Mobile = usr["mobile"].InnerText;
   16. XmlNodeList addrNodes = usr.SelectNodes("address");
   17. foreach (XmlNode addrn in addrNodes)
   18. {
   19. user.StreetName = addrn["streetname"].InnerText;
   20. user.City = addrn["city"].InnerText;
   21. user.Pin = addrn["pin"].InnerText;
   22. }
   23. userList.Add(user);
   24. }
   25. TempData["userData"] = userList;
   26. }
   27. return RedirectToAction("Index");

3. XmlDocument - It represents an XML document which can be used to load, validate, edit, and add XML in a document.
   

   XmlNodeList - It represents an ordered collection of nodes and can retrieve a node at the given index.

   XmlNode - It represents a single node in the XML document and can access the attributes of the node.

   TempData["userData"] - It is used to save the user object which can be accessed in the Index() action method to display user list.

4. Go to the Index() action and add the below code.
   
   1. public ActionResult Index()
   2. {
   3. if (TempData["userData"] == null)
   4. {
   5. ViewBag.ShowList = false;
   6. return View();
   7. }
   8. else
   9. {
   10. List<UsersModel> lst = (List<UsersModel>)TempData["userData"];
   11. ViewBag.ShowList = true;
   12. return View(lst);
   13. }
   14. }

Step 7

Below is the full code of UsersController.

Step 8

Run the project and go for the Users View.

Step 9

Choose the file from computer and click on "Get User List" button.


Step 10

Below is the user list table extracted from userlist.xml file.