带有VS2010和C#的Datagrid Web应用

本文介绍了带有VS2010和C#的Datagrid Web应用的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我已经开发了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. blog.sqlauthority/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. blog.sqlauthority/2010/09/03/sql-server-soft-delete-isdelete-column-your-opinion/[^]