Write from DataTable object into database table 1

[developer155]

What is the best way to move data from in-memory data table into a real database table?

thanks

 

[tperri]

iterate through each row and perform an insert into your database.

 

[developer155]

no chance for bulk insert?

 

[tperri]

not that ive been able to find myself - but you can use a transaction when you do your inserts in case you need to rollback on an error.

 

[Guru7777]

.Net 2.0 contains a bulk copy class where you can merely pass the method a datatable or a datareader and it will do the insert. I use this at work with great success.

http://www.c-sharpcorner.com/Upload...rticleID=11b9eb05-4e81-4841-9220-11fb1a7a019a

----------------------------------------

TWljcm8kb2Z0J3MgIzEgRmFuIQ==

 

[dEVooXiAm]

Guru7777 - that's a third party class, not part of .Net2.0.

------------------
When you do it, do it right.

 

[earthandfire]

dEVooXiAm, look up Bulk Copy with ADO.NET in MSDN Help for VS 2005

It is here on my system:

ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.VisualStudio.v80.en/WD_ADONET/html/83a7a0d2-8018-4354-97b9-0b1d99f8342b.htm


It quite clearly states that SQLBulkCopy is a new class in .NET Framework 2005


Hope this helps.