summing the elements of the an array

[neeraj]

Hi

Can any body give me the syntax for summing the elements of the an
array , without looping

thanks

[Patrice]

I'm not sure what you are looking for. You could update an already computed
sum when you change the value of an array cell. Is this what you meant ? Or
do you meant using the ForEach method (that is your code calls the method
that does the looping for you).

Please be more specific in what you are trying to do (the general answer is
that you have to loop either explicitely or implicitely) or what you are
trying to solve (your current computation is too slow ?)

"neeraj" <ne********@gmail.coma écrit dans le message de news:
11**********************@a75g2000cwd.googlegroups. com...

Hi

Can any body give me the syntax for summing the elements of the an
array , without looping

thanks

[rowe_newsgroups]

I don't thing you can. If you don't want to do any looping, then
perhaps you could use a DataTable instead of an array and use it's
..Compute() method. Is there a reason you don't want to do a loop?

Thanks,

Seth Rowe
neeraj wrote:

Hi

Can any body give me the syntax for summing the elements of the an
array , without looping

thanks

[sergejusz]

Yes, of course :)

Dim values() As Integer = {1, 2, 3}
Dim sum As Integer = values(0) + values(1) + values(2)

:))

Serge
http://www.sergejusz.com

neeraj wrote:

Hi

Can any body give me the syntax for summing the elements of the an
array , without looping

thanks

[neeraj]

Hi Patrice
Thanks for Reply

Actually I am receiving the data from stored procedure in an output
parameter

Like this "23,34,56,322,4445,3234,33344,3334,34344"

and these value also used in whole application as array like this

int [] rupees = {uotParm};

here we can not change the "sql" stored procedure to return the sum
of these value and also can not change the existing "vb.net" code
on whole application

now I want to sum of these value for an purpose, I have already got
the sum of these values by using for each loop but I want to know is
these any method available to get the sum of array aliment by without
use explicit looping.
Patrice wrote:

I'm not sure what you are looking for. You could update an already computed
sum when you change the value of an array cell. Is this what you meant ? Or
do you meant using the ForEach method (that is your code calls the method
that does the looping for you).

Please be more specific in what you are trying to do (the general answer is
that you have to loop either explicitely or implicitely) or what you are
trying to solve (your current computation is too slow ?)

"neeraj" <ne********@gmail.coma écrit dans le message de news:
11**********************@a75g2000cwd.googlegroups. com...

Hi

Can any body give me the syntax for summing the elements of the an
array , without looping

thanks

[lord.zoltar]

neeraj wrote:

Hi

Can any body give me the syntax for summing the elements of the an
array , without looping

thanks

WITHOUT looping? I'm not sure that's possible in VB. Maybe in LISP, but
I doubt it in VB...
if you had to you could write an array_sum procedure to HIDE the
looping...

[Patrice]

Though this would be theorically possible (for example Array.ForEach loops
on an array but is likely more suitable for processing each cell separately
than performing an aggregate operation) it would be more an academic
challenge and I don't really see for now the benefit you expect from this
(you could always create a function that sums an arbitrary array and even
cache the result if the string is the same etc...). Also you'll have likely
anyway to update the code where you want to use this sum while the previous
application was using something else.

Finally LINQ will allow to perform SQL like operations on several sources
including arrays.

For now I would keep the current code unless you can explain what doesn't
work well with it...

----
Patrice

"neeraj" <ne********@gmail.coma écrit dans le message de news:
11**********************@a75g2000cwd.googlegroups. com...
Hi Patrice
Thanks for Reply

Actually I am receiving the data from stored procedure in an output
parameter

Like this "23,34,56,322,4445,3234,33344,3334,34344"

and these value also used in whole application as array like this

int [] rupees = {uotParm};

here we can not change the "sql" stored procedure to return the sum
of these value and also can not change the existing "vb.net" code
on whole application

now I want to sum of these value for an purpose, I have already got
the sum of these values by using for each loop but I want to know is
these any method available to get the sum of array aliment by without
use explicit looping.
Patrice wrote:

I'm not sure what you are looking for. You could update an already
computed
sum when you change the value of an array cell. Is this what you meant ?
Or
do you meant using the ForEach method (that is your code calls the method
that does the looping for you).

Please be more specific in what you are trying to do (the general answer
is
that you have to loop either explicitely or implicitely) or what you are
trying to solve (your current computation is too slow ?)

"neeraj" <ne********@gmail.coma écrit dans le message de news:
11**********************@a75g2000cwd.googlegroups. com...

Hi

Can any body give me the syntax for summing the elements of the an
array , without looping

thanks

[Tom Leylan]

This would work and it's not an explicit loop :-)

Private Sub Test()

Dim a(8) As Integer

a(0) = 23
a(1) = 34
a(2) = 56
a(3) = 322
a(4) = 4445
a(5) = 3234
a(6) = 33344
a(7) = 3334
a(8) = 34344

Debug.WriteLine(SumArray(a, 0).ToString)

End Sub
Private Function SumArray(ByVal a() As Integer, ByVal i As Integer) As
Integer
Dim Result As Integer = a(i)
i += 1
If (i < a.Length) Then
Result += SumArray(a, i)
End If
Return Result
End Function
Tom
"neeraj" <ne********@gmail.comwrote in message
news:11**********************@a75g2000cwd.googlegr oups.com...

Hi

Can any body give me the syntax for summing the elements of the an
array , without looping

thanks

[Mythran]

"Tom Leylan" <tl*****@nospam.netwrote in message
news:eE**************@TK2MSFTNGP05.phx.gbl...

This would work and it's not an explicit loop :-)

Private Sub Test()

Dim a(8) As Integer

a(0) = 23
a(1) = 34
a(2) = 56
a(3) = 322
a(4) = 4445
a(5) = 3234
a(6) = 33344
a(7) = 3334
a(8) = 34344

Debug.WriteLine(SumArray(a, 0).ToString)

End Sub
Private Function SumArray(ByVal a() As Integer, ByVal i As Integer) As
Integer
Dim Result As Integer = a(i)
i += 1
If (i < a.Length) Then
Result += SumArray(a, i)
End If
Return Result
End Function
Tom
"neeraj" <ne********@gmail.comwrote in message
news:11**********************@a75g2000cwd.googlegr oups.com...

>Hi

Can any body give me the syntax for summing the elements of the an
array , without looping

thanks

LOL, nice one...recursion in place of looping....

Mythran

[jeff]

lmao

or...incase you have more than 3 values...

Dim values() as Integer = {1,2,3,...,n}
Dim Sum as Integer = values(0) + values(1) + values(2) + ... + values(n)

"sergejusz" <se*******@gmail.comwrote in message
news:11**********************@a75g2000cwd.googlegr oups.com...

Yes, of course :)

Dim values() As Integer = {1, 2, 3}
Dim sum As Integer = values(0) + values(1) + values(2)

:))

Serge
http://www.sergejusz.com

neeraj wrote:

>Hi

Can any body give me the syntax for summing the elements of the an
array , without looping

thanks

[_AnonCoward]

"neeraj" <ne********@gmail.comwrote in message
news:11**********************@a75g2000cwd.googlegr oups.com...
:
: Hi
:
: Can any body give me the syntax for summing the elements of the an
: array , without looping
:
: thanks
How do you feel about recursion?

================================================== ===
Option Strict On

Imports System

Public Module [module]
public sub main
Dim arr() As Integer = {1, 3, 5, 7, 9}
Console.WriteLine(Sum(arr))
End sub

Function Sum(arr() As Integer) As Integer
Return Sum(arr, LBound(arr))
End Function

Function Sum(arr() As Integer, ndx As Integer) As Integer
If ndx <= UBound(arr) Then
Return arr(ndx) + Sum(arr, ndx + 1)
Else
Return 0
End If
End Function
End Module
================================================== ===
Ralf
--
--
----------------------------------------------------------
* ^~^ ^~^ *
* _ {~ ~} {~ ~} _ *
* /_``>*< >*<''_\ *
* (\--_)++) (++(_--/) *
----------------------------------------------------------
There are no advanced students in Aikido - there are only
competent beginners. There are no advanced techniques -
only the correct application of basic principles.

[Cor Ligthert [MVP]]

Seth,

I have the same curiousity and in my idea all, seen the given answers.

Cor

"rowe_newsgroups" <ro********@yahoo.comschreef in bericht
news:11**********************@q2g2000cwa.googlegro ups.com...

>I don't thing you can. If you don't want to do any looping, then
perhaps you could use a DataTable instead of an array and use it's
.Compute() method. Is there a reason you don't want to do a loop?

Thanks,

Seth Rowe
neeraj wrote:

>Hi

Can any body give me the syntax for summing the elements of the an
array , without looping

thanks

[neeraj]

very funny :-))

On Jan 23, 7:54 pm, "sergejusz" <[e-mail]:

Yes, of course :)

Dim values() As Integer = {1, 2, 3}
Dim sum As Integer = values(0) + values(1) + values(2)

:))

Sergehttp://www.sergejusz.com

neeraj wrote:

Hi

Can any body give me the syntax for summing the elements of the an
array , without looping

thanks- Hide quoted text -- Show quoted text -