How to get all elements under specific nodes RSS

• • Reply
  

  niravparekh

  Member

  704 Points

  427 Posts

  How to get all elements under specific nodes

  Jan 03, 2013 09:08 PM|LINK

  Hi,

  This is my two XML.

  <ReportsList xmlns="http://mynamespace" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <ReportSummary>
    <ReportName>1/7/2012 1/18/2012</ReportName>
    <ReportId>22</ReportId>
  </ReportSummary>
  <ReportSummary>
    <ReportName>Jan</ReportName>
    <ReportId>CC</ReportId>
  </ReportSummary>
  </ReportsList>

  <MyDetails xmlns:ns="http://MyNameSpace" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
    <UserID>m@X.com</UserID> 
    <ReportId>4B7</ReportId>
  
  <Entries Count="3">
  <ExpenseEntry>
  	<UserID>a@X.com</UserID> 
    	<RpeKey>nyjbW3ftOAzPlF$s</RpeKey> 
  	<ApprovedAmount>36.36000000</ApprovedAmount>
  </ExpenseEntry>
  <ExpenseEntry>
  	<UserID>a@X.com</UserID> 
    	<RpeKey>$s9zaDRlRAn2XBNyEsF0</RpeKey> 
  	<ApprovedAmount>36.36000000</ApprovedAmount>
  </ExpenseEntry>
  <ExpenseEntry>
  	<UserID>b@X.com</UserID> 
    	<RpeKey>nyjbW</RpeKey> 
  	<ApprovedAmount>36.36000000</ApprovedAmount>
  </ExpenseEntry>
  
  </Entries>
  
  </MyDetails>

  
  Now what I am looking for is, want to get object of particular nodes, with all the elements underneath that.

  What I means is

  1. In First XML, I want to get an Object of "ReportSummary" which should have two properties "ReportName" and "ReportId" and want to  fill that object out of this XML.

  So want to read from XML File, and create array of "ReportSummary" object where each object will have two properties filled out as "ReportName" and "ReportID".

  2. In Second XML also, I want read this XML from File, get array of "ExpenseEntry" object same way with having "UserID", "RpeKey" and "ApprovedAmount" as its properties. 

  I am using visual studio 2010 so can you tell me what is the best way to achieve this?

  Thanks in advance,

• • Reply
  

  sen338

  Member

  498 Points

  118 Posts

  Re: How to get all elements under specific nodes

  Jan 03, 2013 09:15 PM|LINK

  XmlDocument input = new XmlDocument();

              input.Load(

  @"C:/testfile.xml");

  XmlNodeList List = input.SelectNodes("/Entries/ExpenseEntry");

  Get the xmlnode list which will give you all node under "/Entries/ExpenseEntry" then try to do what ever you want

  Please mark the replies as answers if they help or unmark if not.
  
• • Reply
  

  niravparekh

  Member

  704 Points

  427 Posts

  Re: How to get all elements under specific nodes

  Jan 04, 2013 02:00 PM|LINK

  I tried this, somehow could not get the nodes.

  Is there better way to do this using XDocument?

  I mean where I can fill objects using Linq?

• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: How to get all elements under specific nodes

  Jan 05, 2013 12:41 AM|LINK

  niravparekh

  1. In First XML, I want to get an Object of "ReportSummary" which should have two properties "ReportName" and "ReportId" and want to  fill that object out of this XML.

  So want to read from XML File, and create array of "ReportSummary" object where each object will have two properties filled out as "ReportName" and "ReportID".

  Hi,

  1）  For your first problem，you can really use XDocument to cope with the problem：

  public class Program
      {
          static void Main(string[] args)
          {
              XDocument doc = XDocument.Load("XMLFile1.xml");
   
              //Fetch all the columns
              var columns = from item in doc.Root.Descendants(XNamespace.Get("http://mynamespace") + "ReportSummary")
                            select new
                            {
                                ReportName = item.Element(XNamespace.Get("http://mynamespace") + "ReportName").Value,
                                ReportId = item.Element(XNamespace.Get("http://mynamespace") + "ReportId").Value
                            };
   
              foreach (var item in columns)
              {
                  Console.WriteLine(item.ReportName+"==="+item.ReportId);
              }
          }
      }

  2） Remove "ns" and have a try this:

  public class Program
      {
          static void Main(string[] args)
          {
              XDocument doc = XDocument.Load("XMLFile1.xml");
   
              //Fetch all the columns
              var columns = from item in doc.Descendants(XNamespace.Get("http://MyNameSpace") + "ExpenseEntry")
   
                            select new
                            {
                                UserID = item.Element(XNamespace.Get("http://MyNameSpace") + "UserID").Value,
                                RpeKey = item.Element(XNamespace.Get("http://MyNameSpace") + "RpeKey").Value,
                                ApprovedAmount = item.Element(XNamespace.Get("http://MyNameSpace") + "ApprovedAmount").Value
                            };
   
              foreach (var item in columns)
              {
                  Console.WriteLine(item.ApprovedAmount);
              }
          }
      }

  • Marked as answer by decker dong - msft on Jan 10, 2013 02:27 AM