Hi, I just put a ListView control on a Windows Form, and have set it to have two columns. I'm trying to build a method that uses the selected item of the ListView to find info in the database. The problem I'm having is finding out how to refer to the item that is in the second column of the selected row of the ListView. Here's the line I'm working with:

str = "SELECT Nickname, Base, Target, Pause FROM Backup WHERE Nickname = " & "'" & LstVwPlanBackup.SelectedItems.ToString() & "'"

So the selected item is an object, and not a single value. But what I need is the second column value of that ListView. Does anyone know how I refer to that subitem to get the value?