Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Andreas
2549
Validate values on Insert/Update of row
posted

Hi all,
is there a way to validate the values that are inserted or updated in a new or existing row?

I got a UltraWinGrid bound to a BindingList<string>. I want to make sure no duplicate values are inserted or if a value is changed that it doesn't exist.

Playing around with the AfterRowUpdate/BeforeExit EditMode/BeforeRowUpdate but it just don't sort out.
I cancelled these events but for example if I click into the "add new" row of the grid the item is immediately inserted without having the chance to validate anything.
When catching the BeforeRowUpdate event and validating the value aginst the bound datasource I am not able to restore the previous value.

Is there a way to accomplish this? Maybe a HowTo?

thanks in advance and have a good day
cheers
Andy

  • 469350
    Verified Answer
    Offline posted

    All of the approaches you are using here seem valid to me. You could do this in BeforeCellUpdate, BeforeRowUpdate, or BeforeExitEditMode.

    You would, of course, have to loop through all of the other rows, either in the data source or in the grid, to determine if the value already exists and be sure to ignore the current row that is being edited.

    Regarding reverting to the original value when using BeforeRowUpdate, what you can do is set the RowUpdateCancelAction property on the grid.