The parameterized query ….. expects the parameter ‘@units’, which was not supplied

by

Try this code:

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

And you must check all other parameters for null value. If it null you must pass DBNull.Value value.

More Related Contents:

  1. How can I catch UniqueKey Violation exceptions with EF6 and SQL Server?
  2. How can I round a value in SQL
  3. How do I update a value in C# and SQL Server? [closed]
  4. Connect to client’s SQL Server [closed]
  5. How to pass table value parameters to stored procedure from .net code
  6. Insert 2 million rows into SQL Server quickly
  7. Execute Insert command and return inserted Id in Sql
  8. Best practices for exception management in Java or C# [closed]
  9. C# Equivalent of SQL Server DataTypes
  10. Adding multiple parameterized variables to a database in c#
  11. SQL command INSERT is working but the data not appear in table
  12. Return value from SQL Server Insert command using c#
  13. How can I insert 10 million records in the shortest time possible?
  14. How to pass sqlparameter to IN()? [duplicate]
  15. How to connect to database from Unity
  16. How to insert a data table into SQL Server database table?
  17. Connection timeout for SQL server
  18. Calculated column in EF Code First
  19. MultipleActiveResultSets=True or multiple connections?
  20. Is this a bad practice to catch a non-specific exception such as System.Exception? Why?
  21. Excel error HRESULT: 0x800A03EC while trying to get range with cell’s name
  22. Generate class from database table
  23. Show line number in exception handling
  24. What is passing parameters to SQL and why do I need it?
  25. Why Create Custom Exceptions? [closed]
  26. How can I set up .NET UnhandledException handling in a Windows service?
  27. How do I calculate the equivalent to SQL Server (hashbytes(‘SHA1’,[ColumnName])) in C#?
  28. How to retrieve binary image from database using C# in ASP.NET
  29. Use SQL Server time datatype in C#.NET application?
  30. Is SqlConnection.Close() need inside a Using statement?

Leave a Comment