如何从xml中检索唯一值 [英] how to retrieve unique value from xml

问题描述

hai朋友



i编写了一个查询来使用foreach检索不同的xml节点值

i我试图检索不同的 BankName来自XML的和 TemplateModel

可以用任何一种更好的方式用ienumerable或类似的东西来编写查询



我的Xml如下

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

<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>

我的c＃代码

my c# code

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需要将结果绑定到组合框

i need to bind the result to a combobox

推荐答案

检查此链接..

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



这是一种解析XML数据的简单方法。

使用GetAttribute 功能，您可以访问属性值并将其存储到自定义的类对象中

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

这篇关于如何从xml中检索唯一值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！