Update the whole table, is it possible ?

[teppy1000]

I have a dataTable and now i want to update the whole table to database instead of updating each row

Is there any way to do it ?

thx in advance

[jmcilhinney]

You need to assign Command objects, with the appropriate SQL code in their CommandText properties, to the DeleteCommand, InsertCommand and UpdateCommand properties of a DataAdapter and then call its Update method. There is plenty of ADO.NET information available on MSDN, from the tutorial links in my signature, in the 101 samples and from many other sources. I suggest you roll your sleeves up and do some reading.

[mendhak]

Isn't updating the whole table updating it row by row anyways?