Prevent rowstate change for one column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carl - 06 Apr 2006 12:21 GMT

Hi!

I have an DataTable with one extra column that I've added manually, and is
not in the database. I use this col for various calculations, and it should
never be saved to the db. That works fine, except for one thing: when I
change the value in a row for that col, the RowState becomes Modified.
That's natural I guess, but it's unneccecary because it sends unmodified
rows to the db. Is there a way of marking a col as "computed" or other
technique to avoid changing the rowstate when changing that columns value?

regards

Carl

Reply to this Message

Jim Hughes - 06 Apr 2006 13:50 GMT

datarow.AcceptChanges()

> Hi!
>
[quoted text clipped - 10 lines]
>
> Carl

Reply to this Message

Carl - 06 Apr 2006 14:47 GMT

That is not an option in my case, since there might (will) be other changes
to the row, and I do not wish to accept those changes.

> datarow.AcceptChanges()
>
[quoted text clipped - 12 lines]
>>
>> Carl

Reply to this Message

Jim Hughes - 06 Apr 2006 19:04 GMT

Then do a test to see If Not dataRow.HasChanges() before accepting them.

> That is not an option in my case, since there might (will) be other
> changes to the row, and I do not wish to accept those changes.
[quoted text clipped - 15 lines]
>>>
>>> Carl

Reply to this Message

Prevent rowstate change for one column

Free Magazines