I've tried looking this up but nobody has a tutorial that clears this issue up for me.

I have a listview containing 3 columns and an infinite number of rows. I would like to (on btn_click) add all items from a this ListView to a Label. Here's the catch...I would like to check these items against the items in a database and pull some more information about these parts along with the info that is already in the ListView. Here is my current ListView work so you get an idea of what I'm doing:

'Add PLC Part to the PLC ListView
Private Sub btnAddtoPLCTable_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAddtoPLCTable.Click
' Create List View Item (Row)
Dim lvi As New ListViewItem

' First Column can be the listview item's Text
lvi.Text = cboPLCPartNumber.Text

' Second Column is the first sub item
lvi.SubItems.Add(txtPLCDescription.Text)

' Third Column is the second sub item
lvi.SubItems.Add(spnPLCQty.Text)

' Add the ListViewItem to the ListView
PLCTableList.Items.Add(lvi)

End Sub


Thank you in advance for any help you may offer