a decent method of editing data in a datagrid - that actually works!!

Every event seems to be fired twice, row changing, column changing, currentcell changed.

and Dates I have never ever yet managed to trap an invalid date and highlight the cell. It seems you state the data type as date and of course sql ignores any invalid dates.
The main problem is I guess I could say NULL values not allowed but it's important in this application to allow Null values for dates in certain circumstances.

and even if you use current cell changed you have to save the row number on the first fire and then use that to edit on the second fire.

Very very frustrating or am I missing something here and it's a case of all you have to do .............
any replies / comments gratefully received.

Oh yes and of course I have tried using my own event handlers but that makes no difference, still every event fires twice and boy does it slow the execution of your application down.

and whilst we are on the subject of personal gripes, I believe that CR 9 has got serious problems with it, especially in VS 2003, many many strange errors and quirks - got around them so far but really did not expect this level of problems and yes I am stress testing the aplication at the moment, so I will find them!!!