Updating many rows with ADO.net

[Drathmar]

Right now I have a program that queries a database and saves the data into a a strongly typed dataset Then I perform various calculations on each record and fill in 5 null fields with data Lastly, I click upload and it does a for loop, for each data row and calls the update method to update the database with the calculated values. This works all fine and dandy, except the upload part is rather slow. it looks something like DataAdapter.StoredProcedureUpdate(Primary key, NewValue1, NewValue2, NewValue3, NewValue4, NewValue5) I'm guessing that the upload part is slow because its repeating a process where 3/4 of the work done is not the update function 1. creating the connection 2. connecting and authnicating 3. calling the update procedure 4. closing the connection I'm still somewhat new to ADO.NET so I'm not quite sure if its actually doing this. Does anyone have some good suggestions on a better method? Perhaps a way to call a bulk update through ADO.net or SQL?