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

19 votes153 views2 answers
How to install pyaurogui on windows
C#
0 vote105 views1 answer
Change image of button c#
C#
0 vote109 views1 answer
System.Drawing get from url
C#
27 votes110 views3 answers
Unity get textmesh pro component
C#
-1 vote109 views1 answer
How to compare two strings in c# using if condition
C#
4 votes136 views1 answer
Hyperx quadcast s uk
C#
0 vote118 views1 answer
How to get properties from json in c#
C#
1 vote138 views1 answer
Unity cancel invoke
C#Unity
0 vote110 views1 answer
Fix Array outside the bonus
C#
1 vote131 views1 answer
C# find start and end of month from object date
C#