Click here to Skip to main content
12,400,183 members (46,508 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C# C#4.0
Hi,

i have written insert query on insert button.
when am clicking on insert button it's inserting data in table.
when i click insert button again and again it's inserting same data with new id.

i want if data is already exist in table,it must overwrite the that data.
repeated rows should no be there.

can any one help me.
sample code ll be helpful.

thanks & Regards
sam.198979
Posted 12-Jun-13 1:38am
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

one option is to disable the button once user clicks on button by adding the following:

OnClientClick="this.disabled='true';return true;"

another way is to check for record with same fields. if record already exists then do not insert the data.
  Permalink  
Comments
sam.198979 12-Jun-13 7:57am
   
k if we write insert query on form load then.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Your question is clearly explaining the problem.
sam.198979 wrote:
when i click insert button again and again it's inserting same data with new id.

Clear the controls/variables after inserting the data. So, next time it won't insert the same data.

sam.198979 wrote:
i want if data is already exist in table,it must overwrite the that data.

You should use update command to update existing data in database.


--Amit
  Permalink  
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 12 Jun 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100