Ifill the datagridview,and i need to validateeach data that i fill in.I use the CellEndEdit event to validate each data.Then i click a button to save those data.But i have a problemome user may fill some cells,and they may not leave the last cell

and click the button.so the last cell doesn't happen CellEndEdit event ,and the last data that fill in cannot be validate.This may lead to an error when i save because the illegal data.

I want to ask:how to slove this problem,is there any way that i can leave from the last cell and let CellEndEdit event happen then save or i must validate the date in the click event ,i hope i can come true the first scheme.

my english is poor,thanks.

Hi

It's better to handle the CellValidating event instead of the CellEndEdit event for validating. And you can call the DataGridView.EndEdit() method in theclick event handler function of the save buttonto force the DataGridView to finish the editing.

Best Regards

Zhi-xin Ye

hi,

i got that problem before, i was working on spreadsheets program to be loaded in the gridview and have user edit from there. i was not able to resolve the issue but have an internal arrangement with all the users to press tab to make the changes. just advice your user to do the same of what i did.

thanks for your reply,but mayby i cannot tell every user to do so.

I hope i can slove it myself

Hi

It's better to handle the CellValidating event instead of the CellEndEdit event for validating. And you can call the DataGridView.EndEdit() method in theclick event handler function of the save buttonto force the DataGridView to finish the editing.

Best Regards

Zhi-xin Ye