......
dim mon_total as long
While Not Rs.EOF
Set ItemX = List.ListItems.add(, , Rs.Fields("salarié"))
ItemX.SubItems(1) = Rs.Fields("chantier")
ItemX.SubItems(2) = Rs.Fields("date")
ItemX.SubItems(3) = Rs.Fields("heure")
ItemX.SubItems(4) = Rs.Fields("mo")
mon_total = mon_total + ItemX.SubItems(3)
Label1 = Rs.Fields("num") + 1 & " _" & Text1.Text
Rs.MoveNext
Wend
msgbox mon_total
......
Dim total As Integer = 0 For Each item As ListViewItem In ListView1.Items total += CInt(item.SubItems(2).Text)'3eme colonne Next TextBox1.Text = total.ToString()
Private Sub cbb_nom_Click() Dim Total As Integer Call Connect List.ListItems.Clear Sql = "Select * from pointage where salarié='" & cbb_nom.Text & "'" Rs.Open Sql, Db, adOpenStatic, adLockPessimistic While Not Rs.EOF Set ItemX = List.ListItems.add(, , Rs.Fields("salarié")) ItemX.SubItems(1) = Rs.Fields("chantier") ItemX.SubItems(2) = Rs.Fields("date") ItemX.SubItems(3) = Rs.Fields("heure") ItemX.SubItems(4) = Rs.Fields("mo") Label1 = Rs.Fields("num") + 1 & " _" & Text1.Text Rs.MoveNext Wend Call Deconnect For Each item As ListViewItem In List.Items total += CInt(item.SubItems(3).Text)'3eme colonne Next TextBox1.Text = Total.ToString() End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim mon_total As Long
For i = 1 To ListView1.ListItems.Count
mon_total = mon_total + ListView1.ListItems(i).SubItems(3)
Next
MsgBox mon_total
Dim mon_total As Long For i = 1 To List.ListItems.Count mon_total = mon_total + List.ListItems(i).SubItems(3) Next Text2.Text = mon_total
Dim dblTotal As Double = 0 Dim dblTemp As Double For Each lvItem As ListViewItem In ListView1.Items If Double.TryParse(lvItem.SubItems(3).Text, dblTemp) Then dblTotal += dblTemp End If Next MessageBox.Show(CStr(dblTotal))