[Solved] Preventing duplicate key values

[Marc Simkin]

 

Hi:

If some of the columns in my grid are: Display Name, Order, Data Type, Required, etc.

I'm trying to figure out how to check the display name column when either a new row is about to be inserted or an existing row is edited to make sure that the value is not already present in any rows.

You can think of this as a unique constraint in SQL.

thanks

marc

[Rosen]

Hi Marc Simkin,

Although your requirement is not in the scope of your components, you may consider using remote validation or implement another custom validator in order to validate this.

Regards,
Rosen
the Telerik team

[Marc Simkin]

Is it possible to do this client side with the OnEdit or OnSave events?

I'm trying to figure out, how I can all the existing rows so thatI can loop through them to check for duplicate.

Using remote validation is expensive, since the data needs to be retrieved from the database.  There is now caching on the front end since there is more than one front end web server.

I origianlly wanted to use Batch Editing mode, however the pop up edit window is not supported in that mode.  As a result, I ended up with Ajax Editing mode.  Which will have perform issues, since for every insert/update, I'm going to the db, retrieving the existing data, making the change, and then saving back to the db.  Adding another set of round trips to the db, just to support remote validation doesn't make sense.

thanks

marc

[Rosen]

Hello Marc Simkin,

I'm afraid that currently the data accessible through the grid's client object is only the current displayed page when the paging functionality is enabled. Therefore, checking only the available items will not yield correct results.
However, even if all items are present, there is always chance another user to have already changed the item making its value duplicated, the check will again yield incorrect result as it will be executed over an old data.

All the best,
Rosen
the Telerik team