[dba-VB] DataSet, view deleted rows

Gustav Brock Gustav at cactus.dk
Fri Feb 22 01:35:36 CST 2008


Hi all

I browsed this tip from FMS and noticed at the bottom a way to view deleted rows of a DataSet should you wish to:

  http://www.fmsinc.com/free/NewTips/NET/NETtip56.asp 

'in order to access the values from the deleted row you can create a filtered dataview

  Debug.WriteLine("Retrieve the values of deleted rows")

  Dim dv As New DataView(dt, "", "", DataViewRowState.Deleted)

  For Each drv As DataRowView In dv
    Debug.WriteLine("ID: " & drv.Item("ID").ToString & _
    ", Name: " & drv.Item("Name").ToString)
  Next

/gustav





More information about the dba-VB mailing list