xml help [Answered]RSS

• • Reply
  Melody_xxxx

  Member

  77 Points

  74 Posts

  xml help

  Dec 15, 2015 08:40 AM|Melody_xxxx|LINK

  i have a xml,I want to get the max value from attribute of a node

• • Reply
  Nan Yu

  All-Star

  18675 Points

  3770 Posts

  Microsoft

  Re: xml help

  Dec 15, 2015 09:02 AM|Nan Yu|LINK

  Hi  Melody ,

  Melody_xxxx

  i have a xml,I want to get the max value from attribute of a node

  You could use Linq to Xml to achieve that . For example , if  xml like：

  <?xml version="1.0" encoding="utf-8"?>
  <FeeGroups>
    <FeeGroup value="1">
      <FeegId>100</FeegId>
      <Fgname>sss</Fgname>
      <FgDetail>dgdgdgdg</FgDetail> /&gt;
    </FeeGroup>
    <FeeGroup value="2">
      <FeegId>101</FeegId>
      <Fgname>sss1</Fgname>
      <FgDetail>rtrtrt</FgDetail>
    </FeeGroup>
    <FeeGroup value="4">
      <FeegId>102</FeegId>
      <Fgname>sss2</Fgname>
      <FgDetail>klklkl</FgDetail>
    </FeeGroup>
    <FeeGroup value="1">
      <FeegId>103</FeegId>
      <Fgname>sss3</Fgname>
      <FgDetail>mnmnmn</FgDetail>
    </FeeGroup>
    
  </FeeGroups>

  If I want to get the max value of FeeGroup ,  code below is for your reference :

              int maxValue = XDocument.Load(@"D:\TEST.xml").Descendants("FeeGroup")
                 .Max(x => (int)x.Attribute("value"));

  Best Regards,

  Nan Yu

  MSDN Community Support
  Please remember to click "Mark as Answer" the responses that resolved your issue.
  If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.