DataAdapter.Update

microsoft.public.dotnet.framework

31 Mar 2006 2:34 PM

Sudhesh

Hi,

Can anyone shed some light on which of the two is more efficient (if at
all) and why?

Scenario A: I have setup the Select, Insert, Update & Delete commands
of a DataAdapter, using Stored Procs (against SQL server). Then I call
the Update method.

Scenario B: I loop through each datarow and call the appropriate stored
procs myself.

Is there a better way to send a whole bunch of rows to SQL server with
less round trips?

Cheers
Sudhesh

3 Apr 2006 5:19 PM

Sudhesh

Anyone????

Sudhesh