Accessing information in a deleted DataRow

[byleth]

Hi,

I'm using strongly typed datasets.

Somewhere in my application i need to access the child rows of a deleted datarow:

deletedRow.GetChildRows

in which i get an exception saying i can't access deleted row information.

i know i can do something like deletedRow.Item("colName", DataRowVersion) but what i need is the child rows and parent rows...

Is there any workarround for this?


thanks in advance

 

[SavantMan]

A quick solution you might try if it's possible in your scenario:

use deletedRow.rejectchanges to reset your rowstate to unchanged, get your child rows, then delete the row again

 

[byleth]

Hi SavantMan,

Thanks for your tip..

the thing is that i'm using constraints and relations in a strongly typed dataset, if i change the rowstate of a deleted row that eventualy has it's parent row with the row state marked as deleted as well, wouldn't i end up getting a constraint error..?

I've found a (bad) solution: a hashtable in which the key is the parent row and the value is an array of deleted childs..

it works but i don't like it.

 

[SavantMan]

Byleth,

You're correct --- if you're deletedRow is a child and it's parent's are deleted, my suggestion won't work. Your solution isn't pretty, but better than anything else I can think of. Someone else here may have a better solution.

 

[chiph]

Umm, if it's deleted, why are you even trying to access it?

Maybe you need to store a cache of "recently deleted, but I might need it anyway" data.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[byleth]

hi chiph,

I need it because i'm updating the dataset recursively.