Disable cell validation on form DataGridView

[Chandrakant81]

Hi,
Some of the columns in my database have format = N2
DataSource is an ArrayList.
I dot want any validation if someone enters invalid value in the column Since it gives problem when i try to close the window in such case.
So how can i disable this validation? Don't want to use any close button too.

Please help.

[Matellis]

Did you try catching the Form Closing event and setting EventArgs Cancel
value to false?

http://msdn2.microsoft.com/en-us/library/ms229603.aspx

[Alphonsus]

Try something like this:

Private Sub EquipmentValidationByCell(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles dgvEquipment.CellValidating

strCellESN = e.FormattedValue

If dgvEquipment.Columns(e.ColumnIndex).Name = "ESNDataGridViewTextBoxColumn" Then

If EquipmentNumberValidation(strCellESN) Then

dgvEquipment.Rows(e.RowIndex).ErrorText = "Invalid ESN - please correct"

e.Cancel = True

End If

End If

End Sub

Hope this helps you!

[Howard]

That's exactly what the CellValidating event is for. You're supposed to set e.Cancel to True if the data fails validation and that prevents the data being committed.