如何计算ListView里第三列的所有值相加？
我代码是这样的：
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
c_id = ListView1.SelectedItems(0).Text
Dim sql As String
Dim ds As New DataSet
sql = "select * from 菜单 where cstr(id)='" & c_id & "'"
Dim cmd As New OleDbDataAdapter(sql, Conn)
cmd.Fill(ds, "菜单")
Dim myvalues(0) As String
Dim listview As New ListViewItem
For i As Integer = 0 To ds.Tables(0).Rows.Count - 1
listview.Text = ds.Tables(0).Rows(i)("id")
listview.SubItems.Add(ds.Tables(0).Rows(i)("菜名"))
listview.SubItems.Add((Format(Val(ds.Tables(0).Rows(i)("价格")), "currency")))
ListView2.Items.Add(listview)
listview = New ListViewItem()
Next
End Sub
我把ListView1的几行压入ListView2后。如何计算ListView2列“价格“的值？
[解决办法]
dim allmoney as double=0.0For i As Integer = 0 To ds.Tables(0).Rows.Count - 1 listview.Text = ds.Tables(0).Rows(i)("id") listview.SubItems.Add(ds.Tables(0).Rows(i)("菜名")) listview.SubItems.Add((Format(Val(ds.Tables(0).Rows(i)("价格")), "currency"))) allmoney+= ds.Tables(0).Rows(i)("价格") ListView2.Items.Add(listview) listview = New ListViewItem() Next listview.SubItems.Add("合计:") listview.SubItems.Add(allmoney) ListView2.Items.Add(listview) listview = New ListViewItem()