接收错误“没有给出一个或多个参数的值”。 [英] Receiving error "no value given for one or more parameters"
本文介绍了接收错误“没有给出一个或多个参数的值”。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨朋友们,
我正在使用后端的Access Table在Visual Studio-2015中开发项目。我在表中插入记录时收到了上述错误。如果我使用两个字段,即CurrYear& SAP_No,它工作正常,但是当我尝试添加THIRD字段即CPF_No时,带参数显示错误。
如果表中的字段名称和字段序列,我该怎么办?是一样的吗?
我的代码如下: -
我的尝试:
私人 Sub BtnSave_Click(发件人作为 对象,e 作为 EventArgs)句柄 BtnSave.Click
' ************* **************
BtnSave.Enabled = False
Dbconnection.Close()
Dbconnection.Open()
' AddEmpCmd.CommandType = CommandType.Text
AddEmpCmd.CommandText = INSERT INTO EMP_MASTER&
(CurrYear,Sap_No,CPF_No)&
VALUES(@CurrYear,@ Sap_No,@ CPF_No);
尝试
' AddEmpCmd.Parameters.AddWithValue( @ CurrYear,CmbYear.Text.ToString())跨度>
<跨度类= 代码注释>'跨度> <跨度class =code-comment> AddEmpCmd.Parameters.AddWithValue(@ Sap_No,TxtSapID.Text.ToString())
' <跨度类= 代码注释> AddEmpCmd.Parameters.AddWithValue( @ CPF_No,TxtCPFNo.Text.ToString())跨度>
AddEmpCmd.ExecuteNonQuery()
Dbconnection.Close()
Catch ex As 异常
MessageBox.Show(ex.Message)
结束 尝试
结束 Sub
解决方案
在取消对参数可以帮助
<预LANG = VB> AddEmpCmd.Parameters.AddWithValue ( @ CurrYear,CmbYear.Text.ToString())
AddEmpCmd.Parameters。 AddWithValue( @ Sap_No,TxtSapID.Text.ToString())
AddEmpCmd.Parameters .AddWithValue( @ CPF_No,TxtCPFNo.Text.ToString())
Hi Friends,
I am developing project in Visual Studio-2015 using Access Table in Back end. I have receive aforesaid error while inserting record in table.If I use TWO fields i.e. CurrYear & SAP_No, it works fine but when I try to add THIRD field i.e CPF_No, with parameter it shows Error.
What can I do where field names and field sequences in table are same ?
My Codes are as follows:-
What I have tried:
Private Sub BtnSave_Click(sender As Object, e As EventArgs) Handles BtnSave.Click
'********************************************************************************************
BtnSave.Enabled = False
Dbconnection.Close()
Dbconnection.Open()
'AddEmpCmd.CommandType = CommandType.Text
AddEmpCmd.CommandText = "INSERT INTO EMP_MASTER " &
"(CurrYear, Sap_No, CPF_No) " &
"VALUES (@CurrYear, @Sap_No, @CPF_No) ; "
Try
' AddEmpCmd.Parameters.AddWithValue("@CurrYear", CmbYear.Text.ToString())
'AddEmpCmd.Parameters.AddWithValue("@Sap_No", TxtSapID.Text.ToString())
'AddEmpCmd.Parameters.AddWithValue("@CPF_No", TxtCPFNo.Text.ToString())
AddEmpCmd.ExecuteNonQuery()
Dbconnection.Close()
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
End Sub
解决方案
Uncommenting the parameters may help
AddEmpCmd.Parameters.AddWithValue("@CurrYear", CmbYear.Text.ToString()) AddEmpCmd.Parameters.AddWithValue("@Sap_No", TxtSapID.Text.ToString()) AddEmpCmd.Parameters.AddWithValue("@CPF_No", TxtCPFNo.Text.ToString())
这篇关于接收错误“没有给出一个或多个参数的值”。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文