Validating duplicate records in asp net
: While working on web application with Sql server i need to remove the repeated records from the table so that i can fetch only unique records and display them.So after searching over internet i got the best trick to delete the duplicate records from the table although the table has the identity field.Without this function, the feature rejects the function because of the structured referencing necessary to accommodate Table objects.
After the operation completes, the On Inserted method is called to raise the Inserted event.
Before the insert operation is performed, the On Inserting method is called to raise the Inserting event.
You can handle this event to examine the values of the parameters and to perform any preprocessing before the Insert operation.