原文出处:http://outofmemory.cn/code-snippet/15232/C-DataTable-get-delete-row-information
VB 版本
'dt 为原Datatable数据表
Dim dtDelete As DataTable = dt.GetChanges(DataRowState.Deleted) 'dtDelete 为所有处于删除状态的数据集合
For Each drAll As DataRow In dtDelete.Rows
If strSqlDelete = String.Empty Then
strSqlDelete = String.Format("{0}", drAll.Item(columns_name1, DataRowVersion.Original))
Else
strSqlDelete = String.Format("{0},{1}", strSqlDelete, drAll.Item(columns_name1, DataRowVersion.Original))
End If
Next