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

10 votes131 views2 answers
C# check if string is empty
C#
0 vote132 views1 answer
C# summary angle brackets
C#
0 vote177 views1 answer
Reference to gameobject in different scene unity
C#Unity
0 vote173 views1 answer
Unity time.fixeddeltatime
C#Unity
0 vote123 views1 answer
Asp.net core update-database specify environment
C#
0 vote134 views1 answer
C# list subfolders
C#
0 vote143 views1 answer
Mysqldump - date
C#
0 vote120 views1 answer
Panning script c# on phone
C#
10 votes125 views4 answers
Unity array c#
C#
0 vote138 views1 answer
Wpf set image source in code behind
C#