Get modified colums only

  • Thread starter Thread starter Chris Karcher
  • Start date Start date
C

Chris Karcher

Is there a way to get only the modified columns of the rows in a DataSet?

When calling DataSet.GetChanges() I'm getting the entire row, whereas I
just want the columns that have been changed. Is this possible?
 
Chris,

Afaik not standard and I don't think you can do that after that you have
made your own rules what means "modified"..

By instance what to do if an item (column is the item description part of
the table) is modified after that another or the item was modified before or
what to do by instance with a new or deleted row.

I hope this gives some ideas,

Cor
 
Hi Chris,

No, there is no support for this out of the box.
Why do you need such feature?
 
I'm wanting to build a custom update statement that only sets the fields
that have been changed.

I supposed that I could always get the DiffGram XML, then compare the
before and after fields by hand. I was just hoping there was a better
way...
 
You can still build it manually - loop through all rows and compare column
original vs current value if you need to.
 
Back
Top