加一列叫del int default(0)
建一张表叫[add_history]
删除时Update那一行为1,
insert时同时把该数据的id插入到[add_history]中
查删除数据:select * from [yourtable] where del=1
查新增数据:select * from [add_history]
OK?
附:
[Flags]
public enum DataRowState
{
// Summary:
// The row has been created but is not part of any System.Data.DataRowCollection.
// A System.Data.DataRow is in this state immediately after it has been created
// and before it is added to a collection, or if it has been removed from a
// collection.
Detached = 1,
//
// Summary:
// The row has not changed since System.Data.DataRow.AcceptChanges() was last
// called.
Unchanged = 2,
//
// Summary:
// The row has been added to a System.Data.DataRowCollection, and System.Data.DataRow.AcceptChanges()
// has not been called.
Added = 4,
//
// Summary:
// The row was deleted using the System.Data.DataRow.Delete() method of the
// System.Data.DataRow.
Deleted = 8,
//
// Summary:
// The row has been modified and System.Data.DataRow.AcceptChanges() has not
// been called.
Modified = 16,
}