Operation did not succeed because the program cannot commit

Question

Hello All,

 

Please help... 

 

In my project i have a datagridview and i have created a cellValidate event of it, and in it i have put the code of

e.cancel = true for certain condition like formating and decimal validation...

now it gives error when i press MDI form's save button to save grid records OR cancel button for cancelling records...

IT shows... exception "Operation did not succeed because the program cannot commit or quit a cell value change"

if i remove e.cancel = true or put e.cancel = false then exception is not occured but it can saves wrong data in database....

Please help....

Thankls in advance...