Solved the problem with this code
Firstly set the DeleteItem property of the BindingNavigator to (none). This
stops the automatic deletion of a record. Do this in the designer, select the binding navigator then scroll thru the properties list to find the delete item.
Add this code you may have to change the private sub name
CODE
Private Sub ClientdataBindingNavigator_ItemClicked(ByVal sender As Object, ByVal e As System.Windows.Forms.ToolStripItemClickedEventArgs) Handles ClientdataBindingNavigator.ItemClicked
If e.ClickedItem Is Me.BindingNavigatorDeleteItem Then
'The user clicked the delete button.
If MessageBox.Show("Are you sure you want to delete the current record?", _
"Confirm Delete", _
MessageBoxButtons.OKCancel, _
MessageBoxIcon.Question, _
MessageBoxDefaultButton.Button2) = Windows.Forms.DialogResult.OK Then
'Delete the record.
Me.ClientdataBindingNavigator.BindingSource.RemoveCurrent()
End If
End If
End Sub
You can now stop the deletion of a record if you so wish
31 Jan, 2008 - 11:49 AM
| 