Get Original-Value of an DataColumn?

D

Daniel Barisch

Is it possible to get the value of a dataColumn, that was stored, before
changes were made (after the last "AcceptChanges")? So that updates with a
Database can be made by hand and not with the standard-update-command (SQL)?

I think of code like

changes = myDataTable.GetChanges(DataRowState.Modified)
for each row in changes
for each col in row
newVal = row.item(col).Value
orgVal = row.item(col).OriginalValue
if not orgVal = newVal then
...
end if
next col
next row

Thanks, D.Barisch
 
P

Pete Wright

In a word, No. Onec you call AcceptChanges, the original versions of rows
and columns are cleared out and are unobtainable. Grab your original version
stuff prior to a call to AcceptChanges on the DataSet.

Hope that helps,

Pete


--
Peter Wright
Author of ADO.NET Novice To Pro, from Apress Inc.


_____________________________
 
D

Daniel Barisch

In a word, No. Onec you call AcceptChanges, the original versions of rows
and columns are cleared out and are unobtainable. Grab your original version
stuff prior to a call to AcceptChanges on the DataSet.

I guess my question was a little bit confusing, what I meant was

1. fill new DataSet with values out of a DB
2. DataSet.AcceptChanges
3. Active Working with the DataSet
4. Compare the values from directly after Step 2 to the values directly
before step 4

In beetween I got a solution:

newVals = DataSet.GetChanges(...)
orgVals = DataSet.GetChanges(...)
orgVals.RejectChanges

==> now it is possible to compare the new and old Values

Or does this not work?

Thanks, D.Barisch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top