Link to home
Start Free TrialLog in
Avatar of gringogordo
gringogordo

asked on

Updating a dataset in memory

Hi

I am loading a large amount of data into a datset and I want to update varuious rows from time to time and select particular rows back

I understand but haven't doe it yet that i can select vaious rows back with dataset.Select but is there a way to update them.

So maybe

Dataset.Update - Set Selected = True where Value1 = 7
Dataset.select (Where Selected = true)


Thanks
ASKER CERTIFIED SOLUTION
Avatar of cubixSoftware
cubixSoftware
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gringogordo
gringogordo

ASKER

Thanks for that.  Its pretty much what I was looking for although I was hoping not to have to loop round.  Although I accept that as you are only looping around the necessary rows this is probably what any under the hood solution would be doing anyway (were it to exist).

I'll assign the points after lunch!

Thanks.
Avatar of cubixSoftware
cubixSoftware
Yeah  it's not the nicest bit of code but we have never found any speed issues with this and then the ease of coding when we finally post back to the database via the dataAdapter.update, e.g. to keep everything in a transaction more than makes up for it!