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.
I am able to validate my value properly but when I try to change it to something valid I get a Data Error. You should never attempt to change the cell value in the handler for this event, because unless you cancel the event (in which case the user is stuck in edit mode), the cell value is set to the value from the editing control immediately after the event finishes.
Empty End Sub Private Shared Function Get Data(By Val select Command As String) As Data Table Dim connection String As String = _ "Integrated Security=SSPI; Persist Security Info=False;" _ "Initial Catalog=Northwind; Data Source=localhost; Packet Size=4096" ' Connect to the database and fill a data table. Also see How to: Compile and Run a Complete Windows Forms Code Example Using Visual Studio.
You can also build this example in Visual Studio by pasting the code into a new project.
To copy the code in this topic as a single listing, see How to: Validate Data in the Windows Forms Data Grid View Control.