Hello Mike,

UltraGrid allows you to check user input in several ways. Depending on how you need to save the data from the grid to its data source you may validate input per cell, per row or on entire grid. So, depending on your application logic you need first to set UltraGrid’s UpdateMode. Then you may validate user input by handling:

• BeforeCellUpdate event. In this event you may check the new value. If it is ok proceed further, if not you may cancel the event. Other approach is to save a reference to the edited cell and set some Boolean flag showing if the new cell value is ok. Then if the cell’s value is not correct cancel BeforeCellDeactivate event and put the cell in edit mode;
• BeforeRowUpdate event. If you use this approach you may need to save the cells’ values in some collection. Cancel the event if there are any incorrect cells. Restore the values of correct cells and ask the user to improve the incorrect ones. You may set some appearance to the incorrect cell or use some other approach.

You can also save the data only when UpdateData is called over the grid. If this is your scenario you will need to check each cell in the grid before call UpdateData. If there are any invalid cells, ask the user to improve them and update data source after all cells are ok.

If you give me some additional information about your scenario I will try to give you solution to your issue.

Please let me know if you have any additional questions.