Object cannot be cast from DBNull to other types

by

I’m thinking that your output parameter is coming back with a DBNull value. Add a check for that like this

var outputParam = dataAccCom.GetParameterValue(IDbCmd, "op_Id");
if(!(outputParam is DBNull))
     DataTO.Id = Convert.ToInt64(outputParam);

More Related Contents:

  1. Determine if a number can be made with prepicked numbers and times
  2. Get URL parameters from a string in .NET
  3. Path.Combine for URLs?
  4. How to get client date and time in ASP.NET?
  5. How to call a VBScript file in a C# application?
  6. How to use non-thread-safe async/await APIs and patterns with ASP.NET Web API?
  7. Json.NET serialize object with root name
  8. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  9. Absolute path back to web-relative path
  10. DropdownList DataSource
  11. Passing data to Master Page in ASP.NET MVC
  12. Pattern for calling WCF service using async/await
  13. Get text/value from textbox after value/text changed server side
  14. how to convert NameValueCollection to JSON string?
  15. How to set attributes values using reflection
  16. How can I remove item from querystring in asp.net using c#?
  17. thread with multiple parameters
  18. When is using the C# ref keyword ever a good idea?
  19. How do you bind an Enum to a DropDownList control in ASP.NET?
  20. No authenticationScheme was specified, and there was no DefaultChallengeScheme found with default authentification and custom authorization
  21. Can I have a variable number of generic parameters?
  22. How can I handle forms authentication timeout exceptions in ASP.NET?
  23. MEF with MVC 4 or 5 – Pluggable Architecture (2014)
  24. How do I force full post-back from a button within an UpdatePanel?
  25. Multiples Table in DataReader
  26. ThreadStaticAttribute in ASP.NET
  27. Unable to find the requested .Net Framework Data Provider. It may not be installed
  28. Can’t find how to use HttpContent
  29. Get first element from a dictionary
  30. How do I get a directory size (files in the directory) in C#?

Leave a Comment