如何从griview中删除一行并插入另一个表 [英] How to delete a row from griview and insert into another table

问题描述

我可以使用向导中的存储过程从gridview中删除一行...但删除的行应该插入到历史表中...请帮助....

I am able to delete a row from gridview using stored procedure from wizard...but the deleted row should be inserted to into an history table...Please help....

推荐答案

逻辑是：

1）在从 SourceTable删除数据之前，将数据插入 HistoryTable

2）从 SourceTable删除数据

The logic is:
1) insert data into HistoryTable before deleting data from SourceTable
2) delete data from SourceTable

INSERT INTO HistoryTable (<field_list>)
SELECT <field_list>
FROM SourceTable
WHERE PKey = @PKey

DELETE 
FROM SourceTable
WHERE PKey = @PKey

这篇关于如何从griview中删除一行并插入另一个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！