cell values validation

[Allen]

Please tell me how to validate the cell values.  If the two values are the same, error it out and do not update them.  Please refer to the PNG.

[Allen]

Can any one help?

[Angel Petrov]

Hello Allen,

One possible realization is to subscribe to the OnBatchEditCellValueChanging client event and check the value in the other cell. If it is equal to the newly entered one you can alert the user and cancel the event. When following this approach the user will be prevented from entering a duplicate value.

Regards,
Angel Petrov
Telerik

[Allen]

Can you give me a sample?  I have check the online documentation, but can't find any.

[Allen]

Can anyone give me example for both client side and server side?  I really can't find any from the documentation.  Thanks

[Angel Petrov]

Hello Allen,

Since the EditMode is set to Batch I would recommend using only a client-side solution. If the controls in the edit item cause a postback the changes made by the user will be lost.

Now to the solution of the problem. As I started in my previous post the correct approach would be to cancel the BatchEditCellValueChanging according to the value in the other cell. According to the version used in the real application the related cell value can be obtained in two ways:

1. With the Q2 2013 service-pack version - using the BatchEditGetCellValue and obtaining a reference to the other cell.
2. With the latest internal build you can directly obtain a reference to the related cell in the event handler as there are additional arguments exposed.

Please find in attachments the two fully runnable website which demonstrate the mentioned approaches. Note that we are always improving the Batch edit mode and the internal build provides a richer functionality than the service-pack(keyboard navigation, additional events are exposed and so on). The mentioned features will be included in the upcoming Beta release.

Regards,
Angel Petrov
Telerik

[Allen]

Thank you for your help.  It works great.  However, for some other reason, I have changed the BatchEdit to editForm TextBox.  It no longer work.  For the same senerio, can you give me an example?  Please refer to the PNG file.

[Angel Petrov]

Hi Allen,

One possible solution is to subscribe to the OnUpdateCommand event of the grid and cancel it if the text in the editors is the same:

protected void RadGrid1_UpdateCommand(object sender, GridCommandEventArgs e)
    {
        GridEditableItem editItem = e.Item as GridEditableItem;
        TextBox textBox1 = editItem["Column1UniqueName"].Controls[0] as TextBox;
        TextBox textBox2 = editItem["Column2UniqueName"].Controls[0] as TextBox;
        if (textBox1.Text == textBox2.Text)
        {
            e.Canceled = true;
        }
    }

Another solution would be to subscribe to the OnCommand client event of the grid and cancel the update:

ASPX:

<ClientSettings>
                <ClientEvents OnCommand="OnGridCommand" />
            </ClientSettings>

JavaScript:

function OnGridCommand(sender,args) {
            if (args.get_commandName() == "Update") {
                //check the editor values
                args.set_cancel(true)
            }
        }

Regards,
Angel Petrov
Telerik