bulkCopy.WriteToServer(myBookingDataTable)
 
   bulkCopy.WriteToServer(myBookingss.ToArray())

这是我的整个代码.

Using myConnection As sqlConnection = _
                New sqlConnection(connectionString)
                myConnection.Open()
 
 
                Using bulkCopy As sqlBulkCopy = _
                  New sqlBulkCopy(My.Settings.ConnectionString(),sqlBulkCopyOptions.Default)
 
                    bulkCopy.DestinationTableName = "dbo.Booking"
 
                    Try
                        ' Write from the source to the destination.
                         bulkCopy.WriteToServer(myBookingDataTable)
 
                        'bulkCopy.WriteToServer(myBookingss.ToArray())
 
                    Catch ex As Exception
                        Console.WriteLine(ex.Message)
 
                    Finally
 
                        bulkCopy.Close()
                    End Try
                End Using