The parameterized query expects the parameter which was not supplied

by

If you pass null value to parameter,you will get this error even after you add the parameter
so try to check the value and if it null then use DBNull.Value

This will work

cmd.Parameters.Add("@Department", SqlDbType.VarChar)

If (TextBox2.Text = Nothing) Then
    cmd.Parameters("@Department").Value = DBNull.Value
Else
    cmd.Parameters("@Department").Value = TextBox2.Text
End If

This will convert the null values from the object layer to DBNull values that are acceptable to the database.

More Related Contents:

  1. Syntax not valid on word ‘ON’ in SQL join statement [closed]
  2. SQL QUERY COUNT THEN ADD
  3. How do I UPDATE from a SELECT in SQL Server?
  4. How to calculate age (in years) based on Date of Birth and getDate()
  5. CROSS JOIN vs INNER JOIN in SQL
  6. INNER JOIN vs LEFT JOIN performance in SQL Server
  7. Function vs. Stored Procedure in SQL Server
  8. How to get difference between two rows for a column field?
  9. Counting DISTINCT over multiple columns
  10. SQL Server SELECT into existing table
  11. How to check if a stored procedure exists before creating it
  12. Insert Into… Merge… Select (SQL Server)
  13. how to declare global variable in SQL Server..?
  14. SQL : in clause in stored procedure:how to pass values
  15. Split values over multiple rows [duplicate]
  16. Must declare the scalar variable
  17. Why does SQL Server round off results of dividing two integers?
  18. How to Map Input and Output Columns dynamically in SSIS?
  19. Find the real column name of an alias used in a view?
  20. How to get the identity of an inserted row?
  21. Insert Update stored proc on SQL Server
  22. SQL Server: should I use information_schema tables over sys tables?
  23. TSQL – How to use GO inside of a BEGIN .. END block?
  24. Finding a Top Level Parent in SQL
  25. SQL Server Cumulative Sum by Group
  26. SQL Server FOR XML Path make repeating nodes
  27. Cumulative Total in MS Sql server [duplicate]
  28. What does ON [PRIMARY] mean?
  29. Export table data from one SQL Server to another
  30. Getting warning: Null value is eliminated by an aggregate or other SET operation

Leave a Comment