如何使用asp.net提交按钮将数据从一个表移动到另一个表 [英] how to move data from one table to another table using asp.net Submit button

问题描述

嗨frnds，



正在使用asp.net project.using C＃SqlServer 2005



我在SqlServer数据库中有2个表



我想在我的asp.net网页上点击提交按钮时将所有数据从表A移动到表B.



请你帮我怎么做？



提前致谢

hi frnds,

am working on asp.net project.using C# SqlServer 2005

I have 2 tables in SqlServer database

I want to move all the data from table A to Table B when submit button clicks on my asp.net webpage.

Please can u help me how to do this ?

Thanks in advance

推荐答案

query="INSERT INTO Table2(Tb2Column1, Tb2Column2)
  SELECT Tb1Column1, Tb1Column2 FROM Table1"
SqlCommand cmd = new SqlCommand(query, con);

注意：

1.数据列的类型应与列的数据类型匹配。

2.您可以选择所需的列数。

3.无法复制具有主键的列。

NOTE:
1. Data Type of column should match with data type of column.
2. You can select desired number of columns.
3. Column with Primary key can not be copied.

CREATE TABLE YOUTABLE_B(ID BIGINT,NAME VARCHAR(200),ADDRESS VARCHAR(500))
CREATE TABLE YOUTABLE_A(ID BIGINT,NAME VARCHAR(200),ADDRESS VARCHAR(500),
					DELETED_TIME SMALLDATETIME NOT NULL DEFAULT GETDATE())

INSERT INTO YOUTABLE_B VALUES(1,'YOUR_NAME','YOUR_ADDRESS')
INSERT INTO YOUTABLE_B VALUES(2,'YOUR_NAME','YOUR_ADDRESS')

Create TRIGGER dbo.TRG_YOU_TRG_NAME
ON dbo.YOUTABLE_B
FOR DELETE
AS
BEGIN
   INSERT INTO dbo.YOUTABLE_A
   (ID,NAME,ADDRESS,DELETED_TIME)
   SELECT ID,NAME,ADDRESS,getdate()
   FROM deleted;
END;
GO

DELETE FROM YOUTABLE_B WHERE ID = '1' -- or delete all. 
--on submit button you write ^ above Query 
-- data of table B will be inserted in TAble B automatically when trigger fired on it

select * from YOUTABLE_B
select * from YOUTABLE_A

希望如此它对你有用

这篇关于如何使用asp.net提交按钮将数据从一个表移动到另一个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！