Code :

 
{
        try
        {
            using (var objConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["test"].ConnectionString))
            {
                objConn.Open();
                var transaction = objConn.BeginTransaction();
                using (var bulkCopy = new SqlBulkCopy(
                    objConn,
                    SqlBulkCopyOptions.FireTriggers | SqlBulkCopyOptions.CheckConstraints,
                    transaction))
                {
                    bulkCopy.DestinationTableName = structImport.nomTable;
 
                    for (int i = 0; i < structImport.attributs.Length; i++)
                        bulkCopy.ColumnMappings.Add(ValidDataTable.Columns[i].ToString(), structImport.attributs[i]);
                    bulkCopy.WriteToServer(ValidDataTable);
                    transaction.Commit();
                    success("import de " + ValidDataTable.Rows.Count + " données");
                }
            }
            pnlPopup.Visible = false;
        }
        catch (Exception ex)
        {
            erreur(ex.Message);
        }