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