Prevent from duplicate insertion on save button

Question

I have a problem that when I am inserting data from web page than sometime duplicate data(means 2 rows) going to insert and sometime insert single data properly. So what we can do for prevent duplicate insertion.

Hold On · Answer

Make a stored procedure. See below sample. ALTER PROCEDURE [dbo].[spInsertAgents] -- Add the parameters for the stored procedure here (@AgentID nvarchar(50) @AgentName nvarchar(255) @Gender nvarchar(50) @Address nvarchar(255) @Phone nvarchar(255) @Seller nvarchar(50) @branch nvarchar(50) @CreditLimit decimal (30 2)) AS BEGIN IF ( SELECT COUNT (*) from Agents where AgentID=@AgentID) = 0 begin INSERT INTO [dbo].[Agents] ([AgentID] [AgentName] [Gender] [Address] [Phone] [Seller] [BranchCode] [CreditLimit] ) VALUES (@AgentID @AgentName @Gender @Address @Phone @Seller @branch @CreditLimit) END ELSE BEGIN RAISERROR( 'Agent already exist.' 161) RETURN END END

Rafnas T P · Answer

may be the event is firing two times or more please put break point and check if that event is firing more than one time

Tapan Patel · Answer

Or you can use the unique index to prevent the duplication but if possible have a primary key constraints accross the columns you would like to be unique or else create an unique index on those.

Vishal Jadav · Answer

Hi Are you re-posting your form data ? it may cause the issue. can you please be more specific on your code ? Thank you.

Manas Mohapatra · Answer

First you need to find out form where(in code) it inserts double records. Once you catch it resolve the same. Secondly before inserting you need to check if the row is exist in database. Or you can make some column as unique key. Is there any other app which is interacting to your Databse or any trigger is there in database. Please verify.

Murari Jha · Answer

hii Amit ji but the scenario was I couldn't use primary key means I don't have any unique column .

Amit Gupta · Answer

Make that column as primary key