代码如下:
static void WriteToDatabase(DataTable dt)
{
string connString = "Data Source=10.33.11.1;Initial Catalog=crm;Persist Security Info=True;User ID=sa;Password=sa";
using (SqlConnection connection = new SqlConnection(connString))
{
SqlBulkCopy bulkCopy = new SqlBulkCopy
(
connection,
SqlBulkCopyOptions.TableLock |
SqlBulkCopyOptions.FireTriggers |
SqlBulkCopyOptions.UseInternalTransaction | SqlBulkCopyOptions.KeepIdentity,
null
);
bulkCopy.DestinationTableName = "OutBoundCall";
connection.Open();
bulkCopy.WriteToServer(dt);
connection.Close();
}
}