带有VS2010和C#的Datagrid Web应用 [英] Datagrid web app with VS2010 and C#

问题描述

我已经开发了datagrid网站，其中有编辑"，删除"，选择"和插入"按钮来完成它的工作.

我的问题是:由于任何原因删除行时，将被丢弃，但是我想看看如何在SQL TABLE中查看已删除的信息.
非常感谢.

I have developed datagrid Web site in which I have Edit, Delete, Select and Insert button to do it''s job.

My question is : when I delete the row due to any reason will be gone to garbage but I want to see how I can view deleted information in SQL TABLE.
Thank you very much.

推荐答案

您可以在表中添加一个位"类型列"IsDeleted"，而该记录可以标记为已删除从表中实际删除它的方法.

要删除记录时，只需将IsDeleted标志设置为1.

http://blog.sqlauthority.com/2010 /09/03/sql-server-soft-delete-isdelete-column-your-opinion/ [

You can add a ''bit'' type column ''IsDeleted'' in the table where the record can be marked as deleted instead of actually deleting it from the table.

When you want to delete a record, then only set the IsDeleted flag to 1.

http://blog.sqlauthority.com/2010/09/03/sql-server-soft-delete-isdelete-column-your-opinion/[^]

这篇关于带有VS2010和C#的Datagrid Web应用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！