C Christophe Jul 2, 2003 #1 How can i update several rows in a table at once ? I use a OleDbConnection. Perhaps whith a loop ? Christophe
How can i update several rows in a table at once ? I use a OleDbConnection. Perhaps whith a loop ? Christophe
J Jem Jul 2, 2003 #2 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
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
