DataTable to SQL server table

[Necqui Teja]

Is there a quick and effcient way to insert records into SQL Server database
from a DataTable (DataTable dt when the DataTable and the SQL Server
table contain the same field names and attributes.

I'm using C# VS2005 Beta 2.

Thanks.

 

[Sahil Malik [MVP]]

Try SqlBulkCopy along with DataTableReader

 

[W.G. Ryan MVP]

Sahil's way is the best way I konw of with 2005 but as an FYI, you can use
the old way of setting AccpetChangesDuringFill to false on your data
adapter, and then using that dataset and using a second adapter to update
your destination http://www.knowdotnet.com/articles/datasetmerge.html

SqlBulkCopy rocks though.
http://msmvps.com/williamryan/archive/2004/07/10/9890.aspx