Click here to Skip to main content
15,891,431 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hai friends

i have written a query to retrieve distinct xml node value using foreach
i am trying to retrive distinct BankName and TemplateModel from XML
can any one just a better way to write the query with ienumerable or something like that

my Xml is as follows
XML
<Bank>
  <BankName BankName="DohaBank" TemplateModel="CT1">   
      <ChqBasics>      
      </ChqBasics>
      <XandYPosition>       
      </XandYPosition>
  </BankName>
  <BankName BankName="DohaBank" TemplateModel="CT2">   
      <ChqBasics>       
      </ChqBasics>
      <XandYPosition>        
      </XandYPosition>    
  </BankName>  
  <BankName BankName="IBQ" TemplateModel="CT1New">
        <ChqBasics>     
      </ChqBasics>
      <XandYPosition>     
      </XandYPosition>
   </BankName> 
</Bank>


my c# code
C#
public List<string> bankload()
       {
           List<string> bankname=new List<string>();
           XDocument doc = XDocument.Load("newtest.xml");
          var result= (from item in doc.Descendants("BankName")
                   select (string)item.Attribute("BankName")).Distinct();
          foreach (var item in result)
          {
              bankname.Add(item.ToString());
          }
           return bankname;
       }

       public static List<string> templateload(string bankname)
       {
           List<string> templatename = new List<string>();
           XDocument doc = XDocument.Load("newtest.xml");
           var result = (from item in doc.Descendants("BankName")
                         where item.Attribute("BankName").Value == bankname
                         select (string)item.Attribute("TemplateModel")).Distinct();
           foreach (var item in result)
           {
               templatename.Add(item.ToString());
           }
           return templatename;
       }


i need to bind the result to a combobox
Posted

1 solution

Check this link..
http://www.c-sharpcorner.com/UploadFile/167ad2/read-xml-file-using-xml-reader-in-C-Sharp/[^]

This is a simple method for parsing XML data.
Using GetAttribute function you can access the attribute values and store it into a customized class object
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900