How can i update several rows in a table at once ?

[Christophe]

How can i update several rows in a table at once ?

I use a OleDbConnection.

Perhaps whith a loop ?

Christophe

 

[Jem]

Hi,

Can you be more specific? Do you mean update multiple rows with the same
values? If so, have you tried:

UPDATE mytable SET myfield1=foo, myfield2=bar, ... WHERE key1=value1,
key2=value2, ...

Alternatively, please bear in mind that ADO.NET does not support cursors, so
you will need to use a DataSet.

Jem