I want my c# program with datagridview to work almost exaktly like SQL Server Management Studio if you click on "Edit top 200 Rows" in the context menu of a table.
There is no "Save-Button" and you can't put the focus on a other row, if data are false.
Before the focus is left from a row in a datagridview, a verification in C# shall be done, in which the focus loose can be canceled. Something like Before_Row_Update. CellValidating is not working, because it prevents the user from entering data in a different column.
Example: two columns, both have to be filled with data. User enters value in Col 1 and then klicks on other row. Now verification has to be done (error because Col 2 is empty) and the focus shall stay in Col1 but the user must be able to set the focus on Col 2. It would be better if the focus is set automatically to Col 2.
I thought i could use the RowLeaveEvent, but this Event seems not to be cancellable.
Looking forward :-)