Cor Ligthert [MVP]
2/5/2008 5:51:00 PM
Stren,
You cannot, the database is forever working row by row even if you do an
update of a datatable using the DBDataAdapter.
(The same probably with all utilitys. In fact it is processed byte by byte
as every process with computers)
However in this case probably the sample as Kerry wrote is the most simple.
(I would fill a datatable, with a dataadapter, change all rows in the
datatable and then do an update from the datatable).
If you do it simple then you can use the commandbuilder and you probably
need maximal 20 rows of code.
We don't see what database you use, so a sample is difficult to give.
Cor