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

  • Thread starter Thread starter Stren Assaf
  • Start date Start date
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?
 
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
Updating Dataset from XML 4
How to add new row to dataset's table feilds are bounded 3
What is fastest way to insert many records into a SQL server database? 4
Best way to reinvent bulk insert? 2
Fastest way to update DataTable 0

Back
Top