dbnull mysql_vb.net – sqlbulkcopy – 不允許DBNull.Value.？

我正在嘗試下面這兩個調用但是它們都傳回一個異常Customer_ID不允許DBNull.Value.但是當我調試時,我看到我的所有記錄都配置設定了Customer_ID.它是我的資料庫表中唯一一個不可為空的定義.是什麼導緻了這個錯誤？

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