title: Insert data from DataTable to database table
body: <p>What is the easiest and most efficient way to insert data from a DataTable into a SQL Server database table?  For what it's worth, the DataTable and the database table have matching columns.</p>
  
  <p>What I am doing is transferring data from one database to another (separate instances, so I will be using my application as the intermediate "receiver/sender" of data).  I can easily populate a DataTable with a SqlDataAdapater.Fill() call from the source database table.  But I'm trying to find the most proficient way to send that DataTable's data to the final destination database table.</p>
  
  <p>Any suggestions/advice/opinions are much appreciated.</p>
  
  <p><em>EDIT: the destination database table already exists.</em></p>