When I Click Save Button after Save button How to add Duplicate values in database?

Question

3.67/5 (2 votes)

See more:

(When i will click add button Open another division)

and After When i will click Save button Data is saving Sucessfully in Database ,

After Save button is disabled and Enabled Edit and Update and duplicate buttons

When i will click Duplicate button Save record is taken in duplicate ...Next

In Duplicate Button Edit and save options .. NExt I will edit the database ...When I click save button ... Save Another Record( No Update)

Posted 4-Mar-14 17:59pm

Sai Prasad anumolu

Updated 4-Mar-14 18:14pm

v3

Add a Solution

Comments

[no name] 5-Mar-14 0:01am

And when i click one Duplicate button.. then ?

Sai Prasad anumolu 5-Mar-14 0:03am

when I click on Duplicate ..Save Record data is comming, In duplicate button Edit And Save button ... When i click on Save button Save ...Another Record

[no name] 5-Mar-14 0:09am

Please update your question with more descriptive. Thanks!

dan!sh 5-Mar-14 0:05am

Please try to be as descriptive as you can with the question.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Siva Hyderabad · Answer 1 · 2014-03-04T18:13:00

Solution 1

You should Write query like this...
When you click on Duplicate button,then it's automatically saved Oreginal Table and
Changing values will be changed in another Table..

SQL

insert TableBKP
           select * from Table where sno = @keys

           update Table set [date] = @date,reason = @reason,updatedby=@updatedby where sno=@keys

Posted 4-Mar-14 18:13pm

Siva Hyderabad

Updated 4-Mar-14 18:15pm

v2

Comments

Sai Prasad anumolu 5-Mar-14 0:17am

Kk Anna I will try and Present I am using controls (File Upload and text box) i will send U Datatable

Create table Tbl_TextAdds(AddId int Identity(1,1),ImagePath nvarchar(max),MaxCharLength varchar(200),Price Money default 1)

Siva Hyderabad 5-Mar-14 0:20am

@prasad , if you click on duplicate button..then it shows oreginal Database Data..
Now You click on Edit button..Then it's edited Data..Fine..Now Update button is Enable..Yes,
Now You click on Update button Then Updated Data Changed The Original Table with Updation and Changing original Row Data in Another TableBKP.

Sai Prasad anumolu 5-Mar-14 0:26am

Now You click on Edit button..Then it's edited Data..Fine..Now ,Save Button is there Both dupicate and Original ,after save button - Update button is Enable..Yes, another record is saving in database .. How it is possible anna

Sai Prasad anumolu 5-Mar-14 0:20am

Create table Tbl_TextAdds(AddId int Identity(1,1),ImagePath nvarchar(max),MaxCharLength varchar(200),Price Money default 1)

Siva Hyderabad 5-Mar-14 0:29am

insert Tbl_TextAddsBKP
select * from Tbl_TextAdds where sno = @sno

update Table set ImagePath = @ImagePath ,Price = @Price where sno=@sno