I have a data collection with lots of data. I need to update the data source
(SQL server) with these new data. If I fill the data to a data set and use a
sql DataAdapter to insert, will it be faster than looping through individual
data item and using sql command to insert one at a time?

Thanks.

The DataAdapter will generate the inserts for you - but they'll still be
sent one for each new row in the DataSet. For really fast performance
with a 'lot' of data look at using BULK INSERT from a saved file.

brian

-----Original Message-----
From: Yean Wang (B) [mailto:ywang@c...] 
Sent: Thu, 20 Feb 2003 16:36
To: ADO.NET
Subject: [ado_dotnet] DataSource update performance


I have a data collection with lots of data. I need to update the data
source (SQL server) with these new data. If I fill the data to a data
set and use a sql DataAdapter to insert, will it be faster than looping
through individual data item and using sql command to insert one at a
time?

Thanks.

===
Fast Track ADO.NET with C# is a concise introduction to the concepts,
techniques, and libraries that you will need in order to start using
ADO.NET in your applications. The book covers DataSets and Typed
DataSets, accessing data using DataReaders and DataAdaptors, the close
relationship between ADO.NET and XML, how and where to use ADO.NET in
your enterprise applications, and how to use Web Services and ADO.NET to
easily pass data between applications.
http://www.wrox.com/books/1861007604.htm

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003