How can I delete a Row from a database listed in a listview control in vb.net 2008?

[lulaging2000]

I've tried the following code but it doesn't delete and no error message received.

Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
        Dim Station As String = ""
 
        For Each sItem As ListViewItem In lvList.SelectedItems
            Station = Station & sItem.Text
        Next
 
        If Station <> "" Then
            'Delete the selected record
            Dim strDeleted As Boolean
            strDeleted = ExecNonQuery("DELETE * from FuelDistribution WHERE ToStation = '" & Station & "'")
 
            If strDeleted = "True" Then
                MsgBox("Record's deleted.", MsgBoxStyle.Information)
                Call FillList()
            Else
                MsgBox(strDeleted)
            End If
        Else
            MsgBox("Please select record to delete.", MsgBoxStyle.Critical)
        End If
 
    End Sub

[yarbrough40]

try omitting the "*" in your sql statement.


instead of

"DELETE * from FuelDistribution WHERE ToStation = '" & Station & "'"
 

try

"DELETE from FuelDistribution WHERE ToStation = '" & Station & "'"