C# datareadeer return null

// ****** Use MySqlDataReader instead of SqlReader if you are using MySQL *******

//You need to check for IsDBNull:
//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.

Source: stackoverflow.com

Similar codes

0 vote178 views2 answers
How to make a chunk loader in c#
C#
1 vote182 views1 answer
Unity get scrollbar value
C#Unity
-2 votes117 views1 answer
Tryparse string to int c#
C#
5 votes173 views3 answers
C# exit foreach
C#
1 vote200 views1 answer
How to get executable path in wpf
C#
0 vote173 views1 answer
C# create list with range
C#
3 votes162 views1 answer
How do I print something in the console at the start of the game unity
C#
0 vote172 views1 answer
C# nunit test case
C#
1 vote176 views2 answers
C# regex to find number between parenthesis
C#
1 vote184 views2 answers
C# set cursor pos
C#