Perform bulk updates on organic dataset

[SPG]

Hi,

We have some datasets that are not linked to any form of database, it is
just a means for us to pass info about.

We need to perform an update on this dataset, based on a filter. Just like
an SQL statement, IE: UPDATE tableX SET Name = 'xxx' WHERE ID =xx

The only whay I can think of doing this is to perform a row filter on a
view, then loop through modifying each row manually.

Is there a better way to do this?

Steve

 

[Miha Markic [MVP C#]]

Hi,

Hi,

We have some datasets that are not linked to any form of database, it is
just a means for us to pass info about.

We need to perform an update on this dataset, based on a filter. Just like
an SQL statement, IE: UPDATE tableX SET Name = 'xxx' WHERE ID =xx

The only whay I can think of doing this is to perform a row filter on a
view, then loop through modifying each row manually.

Is there a better way to do this?

Not really. You might use DataTable.Select also which does almost the same.