从Access数据库中删除记录 [英] Delete Record from Access Database

问题描述

我想使用Button控件删除记录。编译时没有发生错误，但数据库中仍然存在记录，我的编码如下。为此提供解决方案

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

推荐答案

查看评论以上。

OP使用 Delrec = cmd.CommandText 而不是

cmd.CommandText = Delrec

所以之前的select命令实际上是执行而不是删除。

so the previous select command was actually being executed instead of the delete.

这篇关于从Access数据库中删除记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！