jeva39
Well-known member
Please, I need the correct code to delete a record in a Sql Database. I use this, don´t give an error but neither delete the record
VB.NET:
Private Sub btnBorrar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnBorrar.Click
Try
Dim dtr As DataRow
dtr = Me.dst.Tables("Ayuda").Rows(Me.ActualPosition)
dtr.Delete() ' delete row
' Use a Temp Table
Dim oTablaBorrados As DataTable
oTablaBorrados = Me.dst.Tables("Ayuda").GetChanges(DataRowState.Deleted)
Me.dta.Update(oTablaBorrados)
Me.dst.Tables("Ayuda").AcceptChanges()
Me.btnpri.PerformClick() ' Go to the first record
Catch eUpdate As System.Exception
System.Windows.Forms.MessageBox.Show(eUpdate.ToString())
End Try
End Sub