listview and right clicking [RESOLVED]

[Andy]

I've searched all over here and the msdn. I'm trying to right-click on a row in a listview, extract the data that's in each field, then make a sql statement to delete that information from the database it came from.

basically I just can't figure out how to get the field information.

any ideas?

[chemicalNova]

This what you mean?

Property Value
true if clicking an item selects the item and all its subitems; false if clicking an item selects only the item itself. The default is false.

The FullRowSelect property has no effect unless the View property of the ListView control is set to View.Details. The FullRowSelect property is typically used when a ListView displays items with many subitems and it is important to be able to see selected items when the item text is not visible due to horizontal scrolling of the control's contents.

' Set the view to show details.
    listView1.View = View.Details
' Select the item and subitems when selection is made.
    listView1.FullRowSelect = True

Phreak

[Andy]

I have all that set up. I can't seem to figure out how to do the reverse of inserting the items and subitems.

With lstvwResults
 
                .Items.Add(reader.Item("Artist"))
 
end with

just as an example, this puts the information IN the listview, how do you take the info OUT when the user right-clicks on that row and break it back up into the original strings?

[Andy]

The selected item is .focusedItem. Then, you can index per column starting with 1.

this may be a 2003 thing. Can someone confirm that?