Hi.
We have an object model that return a list of about 2500 lins and i want to
add them to sql as fast as i.

How can I do a bulk insert to sql Using ADO.net?

Thanks

¤ Hi.
¤ We have an object model that return a list of about 2500 lins and i want to
¤ add them to sql as fast as i.
¤
¤ How can I do a bulk insert to sql Using ADO.net?

See if the documentation for BULK INSERT helps:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ba-bz_4fec.asp


Paul
~~~~
Microsoft MVP (Visual Basic)

Hi Ran,

In ADO.NET 2.0, class SqlBulkCopy can be used to bulk copy
dataset to db. But in ADO.NET 1.1, you should implement
bulk insert yourself.

In my experience, I used StringBuilder to build a large
string and write to a text file, then perform bulk insert
the file content to db. It's much much faster then insert
row by row loop thru datatable.

HTH

Elton Wang
elton_w***@hotmail.com

lins and i want to
Show quoteHide quote

Excel ADO question
Updating a Dataset: How the Adapter works inside ?
OleDbReader and select query problem
DataReader - RowsAffected property
Suppress finalize in dataset constructor???