quotes in quotes in VB.NET?

Question

Hey, I'm using VB.NET 2005 and am trying to add a DELETE statement to a command. Here's the code:

Dim strDelete as string = _

"DELETE * FROM Families WHERE Name = '" & lvfamilies.selecteditems & " ' "



This previously worked in VB6 but now it tells me array bounds cannot appear in type specifiers. Any ideas?

Answer 1

Selected ItemS is a collection (More than one) Try using SelectedItem .

Answer 2

im not sure what lv is but if you were using a drop down list

it would be ddlwhatever.selectitems.value

you need to add the .value after lvfamilies.selecteditems