SQL Data Reader – handling Null column values

by

You need to check for IsDBNull:

if(!SqlReader.IsDBNull(indexFirstName))
{
  employee.FirstName = sqlreader.GetString(indexFirstName);
}

That’s your only reliable way to detect and handle this situation.

I wrapped those things into extension methods and tend to return a default value if the column is indeed null:

public static string SafeGetString(this SqlDataReader reader, int colIndex)
{
   if(!reader.IsDBNull(colIndex))
       return reader.GetString(colIndex);
   return string.Empty;
}

Now you can call it like this:

employee.FirstName = SqlReader.SafeGetString(indexFirstName);

and you’ll never have to worry about an exception or a null value again.

More Related Contents:

  1. Read data from SqlDataReader
  2. Check for column name in a SqlDataReader object
  3. Invalid attempt to read when no data is present
  4. Can you get the column names from a SqlDataReader?
  5. convert from SqlDataReader to JSON
  6. How to get number of rows using SqlDataReader in C#
  7. Multiples Table in DataReader
  8. How to get nullable DateTime out of the database
  9. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  10. Tree data structure in C#
  11. Create a shortcut on Desktop
  12. How do I alias a class name in C#, without having to add a line of code to every file that uses the class?
  13. Bind to SelectedItems from DataGrid or ListBox in MVVM
  14. How to implement a progress bar using the MVVM pattern
  15. Why does it appear that my random number generator isn’t random in C#?
  16. How can I bring my application window to the front? [duplicate]
  17. Check if two lists are equal
  18. Colour Individual Items in a winforms ComboBox?
  19. Using Razor outside of MVC in .NET Core
  20. Algorithm for intersection of 2 lines?
  21. Calling a Javascript function in the C# webBrowser control
  22. linq distinct or group by multiple properties
  23. What does N’ stands for in a SQL script ? (the one used before characters in insert script)
  24. What does LINQ return when the results are empty
  25. How to transform XML as a string w/o using files in .NET?
  26. GUIText is deprecated, so what should I use instead of it?
  27. “Child actions are not allowed to perform redirect actions”
  28. How to construct Order By Expression dynamically in Entity Framework? [duplicate]
  29. Why and how does C# allow accessing private variables outside the class itself when it’s within the same containing class?
  30. How to install Python for .NET on Windows

Leave a Comment