Delete Record from Access Database

See more:

ASP.NET

Hi,


I want to Delete record using Button control. There is no error occurred in compile but record still exist in database my coding is below. Give Solution for this

cn = New OleDbConnection("Provider= Microsoft.Jet.Oledb.4.0;Data source =" & Server.MapPath("DEO.mdb"))
        cn.Open()
        cmd = New OleDbCommand("select FileName from Paripatra", cn)

        Dr = cmd.ExecuteReader


        If Dr.HasRows = True Then

            Dr.Read()

            Dim Delrec As String

            Delrec = "DELETE from Paripatra where FileName = '" & Session.Item("strfile") & Session.Item("Extent") & "'"

            'Delrec = " Update from Paripatra"
            Delrec = cmd.CommandText
        End If

        Dr.Close()
        cmd.ExecuteNonQuery()

    End Sub
End Class