Killsoft Sugdok

how to delete record in ms access using vb.net

Go down

how to delete record in ms access using vb.net

Post by putayputay on Mon Mar 11, 2013 6:51 am

Try
Dim SqlQuery As String = "DELETE FROM FullNameTable WHERE ID = " & id & ";"
Dim SqlCommand As New OleDbCommand

With SqlCommand
.CommandText = SqlQuery
.Connection = conn
.ExecuteNonQuery()
End With
MsgBox("One record deleted..")

txtFName.Text = ""
txtMName.Text = ""
txtLName.Text = ""

Catch ex As Exception
MsgBox(ex.Message)
End Try

putayputay
Newbie
Newbie

Posts : 10
Join date : 2013-03-09

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum