calculate sum of column SAti in LISTview in C#

Question

calculate sum of column total in LISTview in C#

 while (rd.Read())
 {
     usersNB.Add(new userNB
     {
         //my sql
         
         Vrijeme = rd.IsDBNull(rd.GetOrdinal("VRIJEME")) ? string.Empty : rd.GetString(rd.GetOrdinal("VRIJEME")),
         Osoba = rd.GetString("OSOBA"),
 Sati = rd.IsDBNull(rd.GetOrdinal("SATI")) ? string.Empty : rd.GetInt32(rd.GetOrdinal("SATI")).ToString()
                   


 }

Need to sum last column SATI

Naimish Makwana · Answer

To calculate the sum of the column SATI in a ListView  you can iterate over the items in the ListView and add the values of the SATI column. Here is an example of how you can do it: int sum = 0; foreach (ListViewItem item in listView1.Items) { sum += int.Parse(item.SubItems[SATI].Text); } Console.WriteLine(The sum of the SATI column is  + sum); In this code listView1 is the name of your ListView . This code assumes that the SATI column values are integers. If they are not you may need to adjust the parsing method accordingly. Please replace listView1 and SATI with your actual ListView name and column name. Please note that this is a simple example and error checking is not included. You might want to add error checking to ensure that the values in the SATI column can be parsed to integers. If the SATI column might have null or empty values you should check for these before trying to parse the values. Also this code should be placed where it makes sense in your program such as after you’ve finished adding items to the ListView . Thanks