Getting the sum of a specific attribute in a node list

(0) Share

Report

Posted on by Pete_N

1,695

I'm trying to get the sum of the @valueOf attribute from a node list. There can be x number of records

if for instance there are three records , my code below only gets the first record 3 times

                                        Dim _values As XmlNodeList = _temp_xml_Doc.SelectNodes("/BACSDocument/Data/ARUDD/Advice/OriginatingAccountRecords/OriginatingAccountRecord/ReturnedDebitItem")
                                        Dim Counter As Integer = 0
                                        For Counter = 1 To _values.Count
                                            Dim x As XmlAttribute = _temp_xml_Doc.SelectSingleNode("/BACSDocument/Data/ARUDD/Advice/OriginatingAccountRecords/OriginatingAccountRecord/ReturnedDebitItem/@valueOf")
                                            _totalvalue = _totalvalue + CDec(x.Value)
                                        Next

*This post is locked for comments

All responses (1)

Answers (0)

Aric Levin 30,188 Moderator on at

Like (0)

Report

RE: Getting the sum of a specific attribute in a node list

Hi Pete,

How is this question associated with Dynamics CRM?

Have you tried msdn or visual studio forums?

social.msdn.microsoft.com/.../home

developercommunity.visualstudio.com

Hope this helps