vb.net - 数据类型不匹配 VB.net 和 Access 数据库

Question

在我的删除按钮单击事件中，我得到一个附加信息：没有为一个或多个必需参数提供值。在我的 Access 数据库中，CustNo 是短文本的数据类型

    Private Sub btnDelete_Click(sender As Object, e As EventArgs) Handles btnDelete.Click

    Dim custNumber As String
    custNumber = txtCustNo.Text
    Dim command As OleDbCommand


    Dim deleteQuery As String = "DELETE FROM TblLabelCustom_copy WHERE [CustNo]= @custNo"
    command = New OleDbCommand(deleteQuery)
    command.Parameters.AddWithValue("@custNo", OleDbType.VarChar).Value = custNumber
    ExecuteQuery(deleteQuery)
    loadGrid()

End Sub

标签： vb.netwinformsms-access