What is the fastest way to update all rows of a table in a dataset

S

Stren Assaf

Hello and thanks for your help :)

I have uploaded an xml into a dataset so now it contains a single table
filled with the xml values. I need to update one of the fields in all the
rows with a constant value.

What is the fastest way of doing it

Btw: I don not have a database to which I can save the table and then
execute an update command.

Any ideas?
 
K

Kerry Moorman

Stren,

Haven't you already received answers to this question?

You must update the appropriate field for each row in the datatable, using a
loop. You cannot execute an sql statement to update the entire datatable.

Kerry Moorman
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I update a an entire table in a dataset? 7
update database from dataset 2
UpdateDB from DataSet 4
Fastest Method to add rows to a dataset? 3
Updating Dataset from XML 4
Fastest way to update DataTable 0
Update database using DataAdapter for DataSet populated from XMLfile? 3
Adding rows of data to Untyped DataSet 2

Top