Retrieving Original Values From Updated DataRow?

[Axel Dahmen]

Hi,

After my program has updated rows in a DataTable I'd like to retrieve the
original values of some updated rows. Is this possible?

TIA,
Axel Dahmen

 

[Jignesh Desai]

Yes Axel, its very much possible using DataView control and its RowState
property.

OR

dr.Item(0, DataRowVersion.Original) where dr is instance of DataRow


Regards
Jignesh Desai - MVP
Blogs @ http://dotnetjini.jigneshdesai.com/Blogs/default.aspx
..NET Training Programs : http://dotnetjini.jigneshdesai.com/Training.aspx

 

[Cor Ligthert [MVP]]

Axel,

I don't think that is possible if you don't save them first if you are
updating using the original dataset and not only the changes or another copy
of that.

The dataadapter.update has an inbuild acceptchanges. Therefore everything
will be set to unchanged.

I hope this helps,

Cor

 

[Axel Dahmen]

Great!

Thanks a lot, Jignesh.

-------

Yes Axel, its very much possible using DataView control and its RowState
property.

OR

dr.Item(0, DataRowVersion.Original) where dr is instance of DataRow


Regards
Jignesh Desai - MVP
Blogs @ http://dotnetjini.jigneshdesai.com/Blogs/default.aspx
.NET Training Programs : http://dotnetjini.jigneshdesai.com/Training.aspx