The parameterized query expects the parameter which was not supplied c# SQL

Question

I am new in SQL and C# and I encountered this SQL error.

The parameterized query '(@pid nvarchar(4000),@desc nvarchar(4000),@cat nvarchar(4000),@p' expects the parameter '@pid', which was not supplied.

I really need help. Thanks!

 public void InsertRecord()
    {
        SqlCommand cmd = new SqlCommand("INSERT INTO PRODUCTS VALUES (@pid, @desc, @cat, @price, @scode)", myCon);
        cmd.Parameters.AddWithValue("@pid", productID);
        cmd.Parameters.AddWithValue("@desc", description);
        cmd.Parameters.AddWithValue("@cat", category);
        cmd.Parameters.AddWithValue("@price", price);
        cmd.Parameters.AddWithValue("@scode", supplierCode);//corrected the "key codes"

        myCon.Open();
        cmd.ExecuteNonQuery();
        myCon.Close();//added these lines of codes
    }

You are using the INSERT syntax that requires all the fields values to be passed for insertion, do you have just 5 fields in your table PRODUCTS? — Steve, Jan 31 '14 at 16:54
I mean the textbox is enabled but I can't type anything into it. — YellowSubmarine, Jan 31 '14 at 16:56
I can't recall if this is the correct terminology, but check whether that textbox is marked as read-only — Sven Grosen, Jan 31 '14 at 17:03
I can now already type at the textbox. So the product id is not null anymore. But the problem is still the same. — YellowSubmarine, Jan 31 '14 at 17:09
Are all your table fields really meant to be `nvarchars`? Seems a little strange to me to have a product ID field be a full text but maybe there is a reason. — Peter Monks, Jan 31 '14 at 17:14
I don't know why it shows nvarchar there. In my table, I defined those as varchar,varchar,varchar,decimal, and varchar — YellowSubmarine, Jan 31 '14 at 17:20
what about trying to add parameters like this instead. cmd.Parameters.Add("@pid", SqlDbType.NVarChar); cmd.Parameters("@pid").Value = productID; — Brandon.Staley, Jan 31 '14 at 17:55
Brandon.Staley I tried sir, sadly nothing happened. The error still occurs :( — YellowSubmarine, Feb 01 '14 at 13:07
possible duplicate of [The parameterized query expects the parameter which was not supplied](http://stackoverflow.com/questions/3865982/the-parameterized-query-expects-the-parameter-which-was-not-supplied) — Gopi, Jun 01 '15 at 17:17

score 5 · Accepted Answer · edited May 23 '17 at 12:15

5

You must check every parameters if they are null. If they are, you have to pass DBNull.Value.

SqlParameter pidParam = command.Parameters.AddWithValue("@pidParam", productID);
if (productID == null)
{
    pidParam.Value = DBNull.Value;
}

source: The parameterized query ..... expects the parameter '@units', which was not supplied

edited May 23 '17 at 12:15

Community

1
1

answered Oct 03 '14 at 14:54

Bartho Bernsmann

2,393
1
25
34

The parameterized query expects the parameter which was not supplied c# SQL

1 Answers1