[RESOLVED] [2008] Deleting From Access DB

[Jonny1409]

Hello,

I'm trying to delete a record from my access db using code and am getting an error message.

My code is as follows:

        Dim mDataPath As String = Application.StartupPath
        Dim strSelectedItem As String = DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(0).Value

        Try
            Using connection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & mDataPath & "\DB.mdb")
                Using command As New OleDbCommand("DELETE * FROM tbl_Data WHERE ID = '" & strSelectedItem & "'", connection)
                    connection.Open()
                    command.ExecuteNonQuery()
                End Using
            End Using
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

The error I'm getting is "Data type mismatch in criteria expression." and it's on the line "command.ExecuteNonQuery()"

[GaryMazzone]

Is ID a text field or a number? If it is a number remove the single qoutes around strSelectedItem

Also remove the * should just be DELETE FROM table Where Condition

[JuggaloBrotha]

Hello,

I'm trying to delete a record from my access db using code and am getting an error message.

My code is as follows:

        Dim mDataPath As String = Application.StartupPath
        Dim strSelectedItem As String = DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(0).Value

        Try
            Using connection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & mDataPath & "\DB.mdb")
                Using command As New OleDbCommand("DELETE * FROM tbl_Data WHERE ID = '" & strSelectedItem & "'", connection)
                    connection.Open()
                    command.ExecuteNonQuery()
                End Using
            End Using
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

The error I'm getting is "Data type mismatch in criteria expression." and it's on the line "command.ExecuteNonQuery()"

What version of VS are you using? If you're using 2005 or newer you should be using an xsd file for this, you can add your delete query via the designer then simply call the delete method and pass it the ID and it'll do it for you.

Also, there's nothing wrong with "DELETE * FROM....." either

[Jonny1409]

Cheers GaryMazzone, that worked a treat !