当我在保存按钮后单击保存按钮如何在数据库中添加重复值？ [英] When I Click Save Button after Save button How to add Duplicate values in database?

问题描述

（当我点击添加按钮打开另一个部门时）



和之后当我点击保存按钮数据在数据库中成功保存时，



禁用保存按钮后启用编辑并更新和复制按钮



当我点击复制按钮时保存记录一式两份...下一页



复制按钮编辑和保存选项.. NExt我将编辑数据库...当我点击保存按钮...另存记录（无更新）

(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)

推荐答案

您应该像这样编写查询...

当您单击复制按钮时，它会自动保存Oreginal Table和

更改值将在另一个表中更改..

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..

insert TableBKP
           select * from Table where sno = @keys

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

这篇关于当我在保存按钮后单击保存按钮如何在数据库中添加重复值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！