Type of conditional expression cannot be determined because there is no implicit conversion between ‘string’ and ‘System.DBNull’

by

The issue is that (as the error message indicates) the conditional expression needs either identical types on both branches, or else there needs to be an implicit conversion from one of the types to the other. In your case, there isn’t one, and so you get the error. One quick fix would be cast one of the values to (object) (which is fine, since DbParameter.Value is of type object anyway.)

So this should work for you:

param7[1].Value = tbLastName.Text.Length > 0 ? tbLastName.Text : (object)DBNull.Value;

More Related Contents:

  1. How to display words that appear more than 'x' times in a text? [closed]
  2. how to get Value that cause exception
  3. Annual calender in asp.net page [closed]
  4. How do I run this code
  5. Can I automatically increment the file build version when using Visual Studio?
  6. Create an array or List of all dates between two dates [duplicate]
  7. How to write a simple Html.DropDownListFor()?
  8. ASP.NET MVC 5 group of radio buttons
  9. An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode
  10. How do I connect to an .mdf (Microsoft SQL Server Database File) in a simple web project?
  11. Web.Config Debug/Release
  12. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  13. ExecuteNonQuery doesn’t return results
  14. Programmatically get Summary comments at runtime
  15. how to find control in edit item template?
  16. Do I have to Close() a SQLConnection before it gets disposed?
  17. Can “EndResponse” increase performance of ASP.Net page
  18. Timer in UpdatePanel
  19. How do I route images using ASP.Net MVC routing?
  20. Sending SMS from an ASP.NET website [closed]
  21. Why do we need a private constructor?
  22. Get UserID of logged-in user in Asp.Net MVC 5
  23. Server tags cannot contain constructs
  24. Can I use ASP.NET MVC together with regular ASP.NET Web forms
  25. How to use Property Injection with AutoFac?
  26. Memory Mapped Files .NET
  27. pass jquery json into asp.net httphandler
  28. HttpWebRequests sends parameterless URI in Authorization header
  29. {version} wildcard in MVC4 Bundle
  30. What are some alternatives to ReSharper? [closed]

Leave a Comment