rowstate.deleted

[Albert]

Does anyone know if it is possible to get information out of a datarow which
has been deleted?

Thanks,

Albert

 

[One Handed Man \( OHM - Terry Burns \)]

Dim d As New DataTable
Dim deletedRows As DataRowCollection

d.DefaultView.RowStateFilter = DataViewRowState.Deleted

deletedRows = d.Rows

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
If U Need My Email ,Ask Me

Time flies when you don't know what you're doing

 

[Erik]

Does anyone know if it is possible to get information out of a datarow which
has been deleted?

Thanks,

Albert

as long as you did not call the AcceptChanges method of the datarow.

Example accessing the data in Column idx of DataRow Row:
If Row.HasVersion(DataRowVersion.Original) Then
Debug.WriteLine(Row(idx, DataRowVersion.Original))
End If

 

[Albert]

This will only give me a collection of deleted rows, i need to see what data
is in the rows which are deleted

 

[Albert]

Doesnt work, i tried following

I delete a row e.g.

dim dtchanges as datatable

dtchanges=dtmain.select(smt=smt)

for each drow in dtchanges
drow.delete
next

etc.

now when i try to get info out of the deleted rows i get an error
I read a row like this.

dim dtdeleted as datatable = dtmain.detectchanges

for each drow in dtdeleted
msgbox drow(0) <----- Error here
next

 

[Albert]

Ok now I see what you mean,

it is the "DatarowVersion.Original". That'll do the trick, thanks!

Albert