使用VB.Net将string.empty值从绑定的文本框更新到MS Access数据库

Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\path\to\your\database.accdb"
Dim connection As New OleDbConnection(connectionString)

connection.Open()

Dim updateQuery As String = "UPDATE YourTable SET YourColumn = ? WHERE ID = ?"
Dim command As New OleDbCommand(updateQuery, connection)

If String.IsNullOrEmpty(yourTextBox.Text) Then
    command.Parameters.AddWithValue("@YourColumn", DBNull.Value)
Else
    command.Parameters.AddWithValue("@YourColumn", yourTextBox.Text)
End If

command.Parameters.AddWithValue("@ID", yourRecordID)

command.ExecuteNonQuery()

connection.Close()