Assign null to a SqlParameter

by

The problem is that the ?: operator cannot determine the return type because you are either returning an int value or a DBNull type value, which are not compatible.

You can of course cast the instance of AgeIndex to be type object which would satisfy the ?: requirement.

You can use the ?? null-coalescing operator as follows

SqlParameter[] parameters = new SqlParameter[1];     
SqlParameter planIndexParameter = new SqlParameter("@AgeIndex", SqlDbType.Int);
planIndexParameter.Value = (object)AgeItem.AgeIndex ?? DBNull.Value;
parameters[0] = planIndexParameter;

Here is a quote from the MSDN documentation for the ?: operator that explains the problem

Either the type of first_expression and second_expression must be the same, or an implicit conversion must exist from one type to the other.

More Related Contents:

  1. An unhandled exception of type ‘System.InvalidOperationException’ occurred in System.Data.dll?
  2. What is the difference between null and System.DBNull.Value?
  3. SqlParameter does not allows Table name – other options without sql injection attack?
  4. Handle DBNull in C#
  5. Why is this code invalid in C#?
  6. WHERE IN (array of IDs)
  7. How to pass XML from C# to a stored procedure in SQL Server 2008?
  8. DBNull if statement
  9. How to create NVarchar(max) Sqlparameter in C#? [duplicate]
  10. Why does the SqlParameter name/value constructor treat 0 as null?
  11. C# Split String before the first number
  12. C# using Tuple with Sum [closed]
  13. Equivalent of typedef in C#
  14. Call asynchronous method in constructor?
  15. c# open a new form then close the current form?
  16. How to run a C# console application with the console hidden
  17. Proper way to implement a never ending task. (Timers vs Task)
  18. How to prevent a SQL Injection escaping strings
  19. How can I join int[] to a character-separated string in .NET?
  20. ValidateCredentials returns true for unknown user?
  21. Closures behaving differently in for and foreach loops
  22. How can I trigger/refresh my main .RAZOR page from all of its sub-components within that main .RAZOR page when an API call is complete?
  23. xUnit : Assert two List are equal?
  24. Backgroundworker won’t report progress
  25. Method overload resolution unexpected behavior
  26. How are String and Char types stored in memory in .NET?
  27. How to create Select List for Country and States/province in MVC
  28. Create a Deep Copy in C#
  29. Kinect SDK player detection
  30. Is there a way in Json.NET serialization to distinguish between “null because not present” and “null because null”?

Leave a Comment