rowstate.deleted

[Albert]

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

Thanks,

Albert

[Erik]

Re: rowstate.delete d

Albert wrote:
[color=blue]
> Does anyone know if it is possible to get information out of a datarow which
> has been deleted?
>
> Thanks,
>
> Albert
>
>[/color]
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

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

Re: rowstate.delete d

Dim d As New DataTable
Dim deletedRows As DataRowCollecti on

d.DefaultView.R owStateFilter = DataViewRowStat e.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

"Albert" <albert@informa nt.nl> wrote in message
news:cg2f7k$8qm $1@reader13.wxs .nl...[color=blue]
> Does anyone know if it is possible to get information out of a datarow[/color]
which[color=blue]
> has been deleted?
>
> Thanks,
>
> Albert
>
>[/color]

[Albert]

Re: rowstate.delete d

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


"One Handed Man ( OHM - Terry Burns )" <news.microsoft .com> schreef in
bericht news:eZbyuPghEH A.712@TK2MSFTNG P09.phx.gbl...[color=blue]
> Dim d As New DataTable
> Dim deletedRows As DataRowCollecti on
>
> d.DefaultView.R owStateFilter = DataViewRowStat e.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
>
> "Albert" <albert@informa nt.nl> wrote in message
> news:cg2f7k$8qm $1@reader13.wxs .nl...[color=green]
> > Does anyone know if it is possible to get information out of a datarow[/color]
> which[color=green]
> > has been deleted?
> >
> > Thanks,
> >
> > Albert
> >
> >[/color]
>
>[/color]

[Albert]

Re: rowstate.delete d

Doesnt work, i tried following

I delete a row e.g.

dim dtchanges as datatable

dtchanges=dtmai n.select(smt=sm t)

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.detectch anges

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


"Erik" <user@domain.in valid> schreef in bericht
news:ObZzlKghEH A.596@TK2MSFTNG P11.phx.gbl...[color=blue]
> Albert wrote:
>[color=green]
> > Does anyone know if it is possible to get information out of a datarow[/color][/color]
which[color=blue][color=green]
> > has been deleted?
> >
> > Thanks,
> >
> > Albert
> >
> >[/color]
> 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[/color]

[Albert]

Re: rowstate.delete d

Ok now I see what you mean,

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

Albert

"Albert" <albert@informa nt.nl> schreef in bericht
news:cg4o2e$5v3 $1@reader13.wxs .nl...[color=blue]
> Doesnt work, i tried following
>
> I delete a row e.g.
>
> dim dtchanges as datatable
>
> dtchanges=dtmai n.select(smt=sm t)
>
> 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.detectch anges
>
> for each drow in dtdeleted
> msgbox drow(0) <----- Error here
> next
>
>
> "Erik" <user@domain.in valid> schreef in bericht
> news:ObZzlKghEH A.596@TK2MSFTNG P11.phx.gbl...[color=green]
> > Albert wrote:
> >[color=darkred]
> > > Does anyone know if it is possible to get information out of a datarow[/color][/color]
> which[color=green][color=darkred]
> > > has been deleted?
> > >
> > > Thanks,
> > >
> > > Albert
> > >
> > >[/color]
> > 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[/color]
>
>[/color]