Hi i am trying to validate entered cell value in ultrawingrid in add/edit mode. 

1) i want to check if cell value in empty in cell leave/row leave(if empty want to prompt a message)

2) want to check if the entered value is already exist in the grid , if exist want to prompt a message that already exist (i am using list<class> for databinding).

i have tried many ways but it's not complete;y working for all the scenario.

below are the code i am using for this.i am not which event is a appropriate to use.

  private voi grTest_BeforeExitEditMode(object sender, BeforeExitEditModeEventArgs e)

       {

  if (OriginalEmployeeList .Exists(element => element == name) == true)

                {

                    e.Cancel = true;

                    MessageBox.Show("Name (" + name + ") already exist");

                        activeCell.Activate();

                    grTest.PerformAction(UltraGridAction.EnterEditMode);

               }

                else {

                    OriginalEmployeeList = DataSource.Employee.EmployeeList.Select(r => r.EmployeeName).ToList();

                }

}

  private void grdDemandCenter_BeforeRowUpdate(object sender, CancelableRowEventArgs e)

        {

 if (OriginalEmployeeList .Exists(element => element == name) == true)

                {

                                   e.Cancel = true;

                    e.Row.DataErrorInfo.SetColumnError("Name", "Name already exist in the list");

                        e.Row.Cells["EmployeeName"].Activate();

                    grdEmployee.PerformAction(UltraGridAction.EnterEditMode);

                }

                else if (name == string.Empty)

                {

                    e.Cancel = true;

                    e.Row.DataErrorInfo.SetColumnError("Name", "Name cannot be empty");

                         grdEmployee.PerformAction(UltraGridAction.EnterEditMode);

                }

                else {

                    e.Row.DataErrorInfo.ClearErrors();

                    OriginalEmployeeList = DataSource.Employee.EmployeeList.Select(r => r.EmployeeName).ToList();

                    grdEmployee.PerformAction(UltraGridAction.ExitEditMode);

                }

}

 private void grdCustomer_InitializeRow(object sender, InitializeRowEventArgs e)

        {

} string s = e.Row.Cells[CustomerName"].Value.ToString();

            if (s == string.Empty)

            {

                e.Row.DataErrorInfo.SetColumnError("CustomerName", "Name cannot be empty");

}  else {

                //e.Row.DataErrorInfo.ResetRowError();

                e.Row.DataErrorInfo.ClearErrors();

            }