Handle DBNull in C#

by

The shortest (IMHO) is:

int stockvalue = (reader["StockValue"] as int?) ?? 0;

Explanation:

  • If reader[“StockValue”] is of type int, the value will be returned, and the “??” operator will return the result
  • If reader[“StockValue”] is NOT of type int (e.g. DBNull), null will be returned, and the “??” operator will return the value 0 (zero).

More Related Contents:

  1. What is the difference between null and System.DBNull.Value?
  2. How can I easily convert DataReader to List? [duplicate]
  3. Assign null to a SqlParameter
  4. Convert rows from a data reader into typed results
  5. Why is this code invalid in C#?
  6. How to fill Dataset with multiple tables?
  7. DBNull if statement
  8. Multiples Table in DataReader
  9. Reading a date using DataReader
  10. whats wrong with this code??(c1.CommandText = "insert into stu values='" + textBox1 + "','" + textBox2 + "'";)
  11. Regex.Match whole words
  12. When to use ref and when it is not necessary in C#
  13. Iterate Multi-Dimensional Array with Nested Foreach Statement
  14. Debug vs. release in .NET
  15. How to connect to SQL server database from a Windows 10 UWP app
  16. Watermark in System.Windows.Forms.TextBox
  17. Should I abstract the validation framework from Domain layer?
  18. Getting all possible combinations from a list of numbers
  19. Use DbContext in ASP .Net Singleton Injected Class
  20. Can you compile C# so it doesn’t need the .NET Framework at runtime?
  21. Can a DbContext enforce a filter policy?
  22. Extension method on enumeration, not instance of enumeration
  23. Enter key pressed event handler
  24. How to send email to multiple address using System.Net.Mail
  25. WebClient accessing page with credentials
  26. Is there any generic Parse() function that will convert a string to any type using parse?
  27. How do you construct a LINQ to Entities query to load child objects directly, instead of calling a Reference property or Load()
  28. Taskbar location
  29. General Observable Dictionary Class for DataBinding/WPF C#
  30. Installing extensions on Visual Studio 2017 mac [closed]

Leave a Comment