XML Group By Based on Attributes

[EDN Admin]

Hi



from the below XML structure I want to group by based on the TimeFrame Attribute , then later add the values of SuccessCount attribute and have one value . Please find the

the XML structure is as below
<Users><br/>
<User ID=""10"" LoginName=""222"" SuccessCount=""3"" FailureCount=""2"" LastAccessedTimeStamp=""1/1/2011 12:55:00 AM"" TimeFrame=""2011-01-01 00:00:00.000""/><br/>
<User ID=""5"" LoginName=""admin"" SuccessCount=""7"" FailureCount=""2"" LastAccessedTimeStamp=""1/1/2011 12:49:00 AM"" TimeFrame=""2011-01-01 00:00:00.000""/><br/>
<User ID=""9"" LoginName=""2222"" SuccessCount=""2"" FailureCount=""8"" LastAccessedTimeStamp=""1/1/2011 12:57:40 AM"" TimeFrame=""2011-01-01 00:00:00.000""/><br/>
<User ID=""7"" LoginName=""msr2"" SuccessCount=""1"" FailureCount=""3"" LastAccessedTimeStamp=""1/1/2011 12:23:20 AM"" TimeFrame=""2011-01-01 00:00:00.000""/><br/>
<User ID=""6"" LoginName=""msr1"" SuccessCount=""5"" FailureCount=""3"" LastAccessedTimeStamp=""1/1/2011 12:59:00 AM"" TimeFrame=""2011-01-01 00:01:00.000""/><br/>
<User ID=""10"" LoginName=""222"" SuccessCount=""3"" FailureCount=""2"" LastAccessedTimeStamp=""1/1/2011 12:55:00 AM"" TimeFrame=""2011-01-01 00:01:00.000""/><br/>
<User ID=""5"" LoginName=""admin"" SuccessCount=""7"" FailureCount=""2"" LastAccessedTimeStamp=""1/1/2011 12:49:00 AM"" TimeFrame=""2011-01-01 00:01:00.000"" /><br/>
<User ID=""9"" LoginName=""2222"" SuccessCount=""2"" FailureCount=""8"" LastAccessedTimeStamp=""1/1/2011 12:57:40 AM"" TimeFrame=""2011-01-01 00:01:00.000"" /><br/>
<User ID=""7"" LoginName=""msr2"" SuccessCount=""1"" FailureCount=""3"" LastAccessedTimeStamp=""1/1/2011 12:23:20 AM"" TimeFrame=""2011-01-01 00:01:00.000""/><br/>
<User ID=""6"" LoginName=""msr1"" SuccessCount=""5"" FailureCount=""3"" LastAccessedTimeStamp=""1/1/2011 12:59:00 AM"" TimeFrame=""2011-01-01 00:01:00.000""/><br/>
</Users>



View the full article