Delete Record from Database

[chrisgeleven]

I cannot figure out how to delete a row from a database with a VB.NET program. Basically when I have the contents of the row being shown in various textboxes and comboboxes, I want to be able to delete the row that contains that particular information by clicking a button. Can anyone help me?

[crpietschmann]

Use SQL, the DELETE statement would do it.

[Pirate]

In case you couldn't figure it out , here you go .

Public Sub DeleteDB(ByVal DelStr As String, ByVal TableStr As String, ByVal ColumnStr As String)
 
                Dim SQLText As String = "DELETE FROM " & TableStr & " WHERE " & ColumnStr & " = " & " '" & DelStr & "'" & ""
 
                Dim objCmd As New OleDb.OleDbCommand(SQLText, MyConnection)
 
                OpenDB.OpenDB()
 
                Try
                    If objCmd.ExecuteNonQuery() Then
                        MessageBox.Show("Data Deleted Successfully ...")
                    Else
                        MessageBox.Show("Can't delete Data")
                    End If
 
                Catch ee As OleDb.OleDbException
                    MessageBox.Show(ee.Message)
                End Try
                CloseDB.CloseDB()
            End Sub

[chrisgeleven]

Where do I get the first OpenDB and CloseDB in these statements?

OpenDB.OpenDB()
CloseDB.CloseDB()

VB.net says the variables aren't declared

[Pirate]

Originally posted by chrisgeleven
Where do I get the first OpenDB and CloseDB in these statements?
OpenDB.OpenDB()
CloseDB.CloseDB()
VB.net says the variables aren't declared

Forget about that . These are routines for opening and closing connection . All what you have to do is , declare a connection obj and use it in place of OpenDB and Close that connection when you are done . Tell me if you are stuck .