How do I solve exception of datagridview "operation did not succeed because the program cannot commit or quit a cell value change"

Hello All,

Please help.. 

In my project i have 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 formatting and decimal validation... 

now it gives error when i press MDI form's save button to save grid 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 occurred but it can saves wrong data in database....

Please help....

Thanks in advance...