multiple rows update

  • Thread starter Thread starter Christophe
  • Start date Start date
C

Christophe

How can i make a update on many rows in a table of my database ?
I use an OleDbConnection.

Perhaps with a loop ?

Christophe.
 
try learning basic sql, you can do multipal row updates with a single update
command.
 
--
____________________________________
Bill Vaughn
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Multiple row updates could mean several things. First, have you made changes
to several rows in a DataSet and you want to post these (several) changes to
the database? In this case, the Update method can do this for you assuming
you've setup the DataAdapter correctly with appropriate UpdateCommand,
InsertCommand and DeleteCommand.
If you want to make a change to a set of rows in the DB (change the salary
of everyone in Cleveland) you can use an UPDATE SQL command with an
appropriate WHERE clause.

hth

--
____________________________________
Bill Vaughn
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top