Delete Record from Access Database

Question

0.00/5 (No votes)

See more:

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

Posted 13-Mar-13 3:56am

Md Jamaluddin Saiyed

Updated 13-Mar-13 4:12am

Richard C Bishop

v3

Add a Solution

Comments

joshrduncan2012 13-Mar-13 9:59am

You need to refresh your table after the deletion takes place, otherwise the record will stay in there.

Md Jamaluddin Saiyed 13-Mar-13 10:08am

I have refreshed it but record not deleted

CHill60 13-Mar-13 10:19am

You've used Delrec = cmd.CommandText so Delrec now contains "select FileName from Paripatra"
Did you mean to use cmd.CommandText = Delrec??

[no name] 13-Mar-13 10:25am

Nicely spotted. This is likely the answer.

Md Jamaluddin Saiyed 13-Mar-13 10:37am

Thank you Very much sir ! Now I got my mistake !! I have solved it !! Thanks again !! I could not found my mistake

CHill60 13-Mar-13 10:48am

That's my pleasure. I'll post it as the solution for any googlers. Please mark as solved

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Accepted Answer · 2013-03-13T04:48:00

Solution 1

See comments above.
OP had used Delrec = cmd.CommandText instead of

cmd.CommandText = Delrec

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

Posted 13-Mar-13 4:48am

CHill60

Comments

Maciej Los 13-Mar-13 16:15pm

+5!

CHill60 13-Mar-13 18:08pm

Many thanks ML

Delete Record from Access Database

1 solution

Solution 1

Add your solution here

Preview 0

Delete Record from Access Database

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us