Updating the dataset into the database in C# .net

Question

Hi, I am using a stored procedure to fetch the data from the database and populating the dataset with the output. I am trying to update some valued to the dataset that is populated.

Now how do i update the modified dataset to the database.

1) Should i update the database by looping through the dataset rows? 2) Will dataadapter.Update(dataset) will work in this case (data fetched using stored procedure) ? 3) which is the efficient way ?

I am using C# .NET 2.0 , SQL 2005

Please help !!!

Answer 1

We built a solution using Microsoft's Enterprise Library Data Access Application Block. There is an UpdateDataSet method one can use to get the changes from a dataset into the database.