How to handle Null Column values of SQLDataReader in C# ?

If you want to handle the Null column values of the sqldatareader object in C#, you can use the SqlReader.IsDBNull method to validate for it.

If the SqlReader.IsDBNull returns true then , the value is considered to be a null value and you can take the ction accordingly.

How to handle Null Column values of SQLDataReader in C# ?

if (!SqlReader.IsDBNull("EmailAddress"))
{
    emp.EmailAddress = sqlreader.GetString("EmailAddress");
}