Hello. I meed some help with this.
I am trying to delete a record from database(SQL Server)
Am i missing something?
Private Sub cmdDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdDelete.Click _DataSet.Tables(0).Rows(CInt(txtCurrent.Text) - 1).Delete() ' tho, it can remove the deleted rows ' we cannot call the DataSet.AcceptChanges method ' because the DataAdapter would not recognize the delete row ' by the time DataAdapter.Update(DataSet) is called. EnableNavigation() cmdSave.Enabled = True ' let user update the underlying database ' after deleting the current record, the current record still points to the ' deleted record (though it cannot be updated). ' The user must MoveNext/Back to view other records. End Sub
txtcurrent. is a textbox that contains the current record number