How to get original DataColumn value from DataRow ?

Question

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

Answer 1

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.