How to get original DataColumn value from DataRow?
12,393
Original values are lost when you call AcceptChanges
(which is usually called when you call Update
on a DataAdapter
or TableAdapter
too). Once the changes are accepted, you can't access the original values, that's probably why your code doesn't work.
Author by
Nikhil Vaghela
Updated on July 27, 2022Comments
-
Nikhil Vaghela almost 2 years
I have a DataTable and i want to figure out the Original column value for all the modified data rows.
I am using following approach to get the Orginal column value before the DataRow was modified
DataRow[] dataRowArray = dataTableInstance.Select(null,null,DataViewRowState.OriginalRows); DataRow originalDataRow = dataRowArray[rowIndex][columnIndex, DataRowVersion.Original]
Please point out what am I doing wrong here ? Above code does not give me the Original column , instead it gives me the latest modified column value.
Thanks.
Nikhil