I was wondering if there is a way to prevent duplicate (conflict) values when insert or edit records in a grid without the usual way of query in the database for already existence. What about the ConflictDetection="CompareAllValues" property in <asp:SqlDataSource> tag?
Thanks
1 Answer, 1 is accepted
0
Maria Ilieva
Telerik team
answered on 17 Jan 2011, 10:35 AM
Hi George,
Note that the ConflictDetection property check if there is a conflict by verifying the old values for the record with the new one entered value, but not all the values in the database. Currently the usual way of query in the database for already existence is a possible approach, as well as defining the dataTable in the database to avoid duplicates.