Exception: No value given for one or more required parameters in VB.NET & MS-ACCESS DB

Question

I work with an Inventory System. I have an error on my code, it says

No value given for one or more required parameters.

and the error was thrown to cmd.ExecuteNonQuery(). What does it mean? can someone help me? By the way this code is for deducting Item Quantity on Database. Sorry for my bad English.

con.Open()
Dim sqlQry As String = "UPDATE [tbl_Stocks] 
                        SET [Quantity] = [Quantity] - @QU 
                        WHERE Products='" & lbPro.Text & "'"
Using cmd As New OleDbCommand(sqlQry, con)
    cmd.Parameters.AddWithValue("@QU", lbQuan.Text)
    cmd.ExecuteNonQuery()
    con.Close()
    MsgBox("Save Successfully!")
End Using

Use a parameter also for the Products value, then check if the fields names are written correctly — Steve, Aug 03 '16 at 08:41
Please [use parameterized SQL instead](http://stackoverflow.com/q/35163361/87698). — Heinzi, Aug 03 '16 at 08:49
@Steve the data type of column Quantity is Number on the database — NiewBiee2020, Aug 03 '16 at 08:55
Are the column names and the table name written correctly?. Usually this error happens with ms-access when you mispell some name. — Steve, Aug 03 '16 at 08:56
Oops, My bad I misspelled the column name product to products. — NiewBiee2020, Aug 03 '16 at 09:04

jonju · Accepted Answer · 2016-08-03T09:03:57.283

0

I don't see any flaw. Try this substitute(a little tweak sending both inputs via parameter)

con.Open()
Dim sqlQry As String = "UPDATE [tbl_Stocks] SET [Quantity] = [Quantity] - @QU " &
                       "WHERE Products=@prod"
Using cmd As New OleDbCommand(sqlQry, con)
    cmd.Parameters.AddWithValue("@QU", lbQuan.Text)
    cmd.Parameters.AddWithValue("@prod", lbPro.Text)
    cmd.ExecuteNonQuery()
    con.Close()
    MsgBox("Save Successfully!")
End Using

edited Aug 03 '16 at 09:03

answered Aug 03 '16 at 08:42

jonju

2,711
1
13
19

i try to use this code but the error "No value given for one or more required parameters." still prompting. – NiewBiee2020 Aug 03 '16 at 08:50
have you noticed the `@prod`?. If not then make sure values of `lbQuan` & `lbPro` are not empty or null – jonju Aug 03 '16 at 08:53
the only problem is I misspelled the column name product to products but the code is working! Thank you! – NiewBiee2020 Aug 03 '16 at 09:06

Exception: No value given for one or more required parameters in VB.NET & MS-ACCESS DB

1 Answers1

Linked