After setting the datasource of the datagridview, it automatically jumps to the Row Validating event which I DONT WANT TO!
This event is raised when the current cell is validated with the new value and the Is Valid property of the Current Cell Validating event is set to ‘true’.
The following code example illustrates a simple condition to handle Row Validation.
In this example, the sum of Expense and Freight is a minimum of 3000, where this is eligible for the discounted price.
Thanks that really worked out for me beside the function I had to put several True/False boolean values in other subs/events aswell to prevent the Row Validating and in fact switched back to Cell Validated.
It is not what I would call elegant but sometimes you have to get it done.