I have EntityDataSource1 and i am allowing user to edit Primary Key column. the column is 5 characters code (string) that user has to enter. I am using telerik Grid and inline editing.

Obviously if duplicate is entered it will thow this error, but i am confused, where in which event to handle this error and display userfriendly error message, also keeping grid in edit mode.


Are you sure you want to allow editing primary key? Maybe check for duplicate prior trying to update?

editing primary key = YES.

The whole point is, i do not wish to fire another query and check for duplicates. I want to rely on database to return error if duplicate.

All i want is to be able to catch error and i am using EntityDataSource1 so just don;t understand which event to catch and write code to display userfriendly error.

Any clues?