I would like to manipulate a cell in my Data Grid View when it is validating so that if the user enters a value that is not valid for the database, but is easily converted to valid data, the program will change the value to an appropriate one.
Alternately, if a user tries to insert a string into an integer column, they get a very long error message which isn't user friendly at all.
If the user inputs a string a message pops up to tell them "only numeric entries are allowed". However if I try to use this code in a column of data populated with numbers I get an error message that says "error happened, parsing commit".
If anyone is able to figure out what the issue is here I would greatly appreciate it! Column Index = 3) Then 'checking numeric value for column 3 only Dim value As String = Data Grid View1.
When the button is clicked, it opens a child window and when closed, goes back to the parent form.
I want to validate the value being inputted in a cell of the DAta Grid View.