Category: LINQ

13 Dec 2015 23:17

Joined:	04/08/2008
Level:	Silver
Points:	116

Points:	5

Find max value of field in xml using Linq

Hi,

I want to find the maximum value of a particular field from XML file.

following is my XML file

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

</FeeGroups>

my requirement is to fetch the maximum value of FeegId from the above xml

Regards

Baiju

#763546

13 Dec 2015 23:39

Joined:	05/06/2009
Level:	Gold
Points:	10245

Points:	2

Following are some tips to do your task

XElement element = XElement.Load("Your.xml");
int max =
element.Elements("FeeGroup").Max(l => int.Parse(l.Value));

By Nathan
Direction is important than speed

#763551

14 Dec 2015 01:53

Joined:	13/06/2007
Level:	Gold
Points:	21327

Points:	3

Use ToArray() method to get all inner text in array with specific element, check following snippet
var textArray = topElement.Elements("FeegId")
.Select(x => x.Value)
.ToArray();
use Max() method of maximum from array, see snippet
string szMax = array1.Max());

Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]

#766188

26 May 2016 02:07

Joined:	21/01/2014
Level:	Silver
Points:	134

Points:	3

Hi
You can use following code

XElement ex = XElement.Load(@"C:\Umesh\Demo\DotnetSpidder\R_D\R_D\input.xml");
var maxval = (from x in ex.Elements("FeeGroup").Elements("FeegId")
select new
{
x.Value
}).ToList().OrderByDescending(y => y.Value).ToList()[0];

Console.WriteLine(maxval.Value);

//-- Hope it will help you !!!!
Thanks
Umesh Bhosale

Find max value of field in xml using Linq

About dotnetspider.com

Quick Links

General

Services