I am getting continuously an error on `ExecuteNonQuery();`. I have tried many ways but don't know where I am wrong.

I am using `float` data type in orderid, price, quantity, discount, order price columns in SQL Server.

Kindly help.

```
string query = "Insert into  dbo.orders (OrderType,Product_Name,Product_Category,Product_Quantity,Product_Price,Date,Discount) values(@txt_rdvalue,@cb_oname,@cb_ocat,@cb_oqty,@txt_oprice,@Date,@txt_disc)";

if (string.IsNullOrWhiteSpace(txt_rdvalue.Text) || string.IsNullOrWhiteSpace(cb_oname.Text) || string.IsNullOrWhiteSpace(cb_ocat.Text) || string.IsNullOrWhiteSpace(cb_oqty.Text))
{
    lbl_incorrect.Text = "please fill up all the fields";
    lbl_incorrect.Visible = true;
}
else
{
    using (SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=Pizza Mania;Integrated Security=True"))
    {
        using (SqlCommand cmd = new SqlCommand(query, con))
        {
            cmd.CommandType = CommandType.Text;
            cmd.Connection = con;

            con.Open();

            cmd.Parameters.AddWithValue("@txt_rdvalue",txt_rdvalue.Text);
            cmd.Parameters.AddWithValue("@txt_orderid",txt_orderid.Text);
            cmd.Parameters.AddWithValue("@cb_oname", cb_oname.SelectedText);
            cmd.Parameters.AddWithValue("@cb_ocat", cb_ocat.SelectedText);
            cmd.Parameters.AddWithValue("@cb_oqty", cb_oqty.SelectedValue);
            cmd.Parameters.AddWithValue("@txt_oprice", (txt_oprice.Text));
            cmd.Parameters.AddWithValue("@txt_disc", txt_rdvalue.Text);
            cmd.Parameters.Add(new SqlParameter("@Date", dateTimePicker1.Value.Date));

            cmd.ExecuteNonQuery();

            MessageBox.Show("Data Inserted");
        }
    }
}

```

The error message I am getting:

> 
> The parameterized query '(@txt\_rdvalue nvarchar(8),@txt\_orderid
>  int,@cb\_oname nvarchar(40' expects the parameter '@cb\_oqty', which was
>  not supplied
> 
> 
>