Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

How to use ADO.Net DataTable to bulk-insert many records into database table?

Avatar of ZuZuPetals
ZuZuPetalsFlag for United States of America asked on
Microsoft SQL Server.NET ProgrammingC#
11 Comments1 Solution3481 ViewsLast Modified:
Is it possible to create a DataTable object, define a few columns, add a few thousand rows, connect it to a database table, then "sync" up and have it insert those rows into a SQL Server database table?

Is this reasonable efficient or is it still "under the covers" doing multiple inserts? (and in that case no need to go through all the hassle of using the DataTable approach?)

Has anyone tried this?

If so, what are the concrete steps of how to create these objects and assign properties to pull this off?
Avatar of Anthony Perkins
This problem has been solved!
Unlock 1 Answer and 11 Comments.
See Answers