View Single Post
  #2 (permalink)  
Old November 5th, 2008, 04:38 PM
Old Pedant Old Pedant is offline
Friend of Wrox
 
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

Create an index on one or more of the fields that should not be duplicated and make the index "unique".

Now you will get an error if you try to create a duplicate.

In other words, solve this in the database, not in your .NET coding.
The Following User Says Thank You to Old Pedant For This Useful Post:
nishanthahe (August 31st, 2009)