public static void BulkCopy(string tableName, System.Data.DataTable insertData) { try { System.Data.SqlClient.SqlBulkCopy copy = new System.Data.SqlClient.SqlBulkCopy(Connection); copy.set_DestinationTableName(tableName); foreach (System.Data.DataColumn column in insertData.Columns) { copy.ColumnMappings.Add(column.get_ColumnName(), column.get_ColumnName()); } copy.WriteToServer(insertData); } catch (System.Data.SqlClient.SqlException exception) { throw WrapDatabaseException(exception); } }