Ateeq Ateeq - 1 year ago 140
SQL Question

The parameterized query expects the parameter which was not supplied where the value is not null

I have a problem with updating a SQLServer table from a DataGrideView in the VB.Net, I know that the exception that I had is because of Null value but I'm sure that the value is set with a valid value, here is the code:

cmd.CommandText = _
"update BillItem set Item=@item1,Quantity=@q1,Price=@price1,TotalPrice=@tp1,BillID=@billId1 where Id=@id1"
cmd.Parameters.Add("@item1", SqlDbType.NVarChar)
cmd.Parameters.Add("@q1", SqlDbType.Int)
cmd.Parameters.Add("@price1", SqlDbType.Float)
cmd.Parameters.Add("@tp1", SqlDbType.Float)
cmd.Parameters.Add("@billId1", SqlDbType.Int)
cmd.Parameters.Add("@Id1", SqlDbType.Int)

cmd.Connection = connection
For i As Integer = 0 To 1
cmd.Parameters(0).Value = DataGridView1.Rows(i).Cells(1).Value
cmd.Parameters(1).Value = DataGridView1.Rows(i).Cells(2).Value
cmd.Parameters(2).Value = DataGridView1.Rows(i).Cells(3).Value
cmd.Parameters(3).Value = Integer.Parse(DataGridView1.Rows(i).Cells(2).Value) * Double.Parse(DataGridView1.Rows(i).Cells(3).Value)
cmd.Parameters(4).Value = Integer.Parse(CurrentBillIDLbl.Text)
cmd.Parameters(5).Value = DataGridView1.Rows(i).Cells(0).Value

Here is the exception:

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll
Additional information: The parameterized query '(@item nvarchar(4),@quantity int,@price float,@tp float,@billId ' expects the parameter '@q1', which was not supplied.

Answer Source

Your CommandText parameters do not match the actual parameters as seen in the error message. The actual query thinks has @item but your example has @item1. Likewise, @q1 is not @quantity. I don't think the code you have shown is in context, you are not using the command text that you think you are.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download