How to sum a field in a List

Question

Sumit Kesarwani · Accepted Answer

"Hi Chintoo, try this:aList.Sum(Function(i) i.AnswerCount)"

Aryan Kumar · Answer

Sure, I can help you with that. Here are the steps on how to sum a field in a list in VB.NET:

Create a new Windows Forms project in VB.NET.
Add a ListBox control to the form.
In the code behind file, add the following code:

VB.Net

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
    ' Initialize the sum variable.
    Dim sum As Double = 0

    ' Iterate through the listbox items.
    For Each item As ListItem In ListBox1.Items
        ' Get the value of the item.
        Dim value As Double = item.Value

        ' Add the value to the sum.
        sum = sum + value
    Next

    ' Print the sum.
    Console.WriteLine(sum)
End Sub

Run the project. When you click the button, the code in the Button1_Click event handler will be executed. The code will iterate through the items in the ListBox control and add the values of the items to the sum variable. The sum variable will then be printed on the console.

Here is an explanation of the code:

The For Each loop is used to iterate through the items in the ListBox control.
The Value property of the ListItem control returns the value of the item.
The Sum variable is used to store the sum of the values of the items in the ListBox control.
The Console.WriteLine method is used to print the sum on the console.

Sumit Kesarwani · Answer

Hi Chintoo, try this:aList.Sum(Function(i) i.AnswerCount)

forum

How to sum a field in a List

Can you answer this question?

2 Answers