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 vote191 views1 answer
List of gender binary terrorists
C#
0 vote186 views1 answer
Android jaca how to pass a imageurl in a recyclerview adapter
C#
0 vote168 views1 answer
C# datareader already open visual studio mysql
C#
1 vote119 views9 answers
Unity vector3.lerp
C#
0 vote172 views1 answer
Godot Duplicate 'global::System.Runtime.Versioning.TargetFrameworkAttribute'
C#
3 votes185 views1 answer
Loop over all values in enum
C#
5 votes195 views5 answers
Decimal c# 2 digits
C#
0 vote158 views1 answer
C# streamreader to file
C#
26 votes186 views3 answers
ModuleNotFoundError: No module named 'requests'
C#
24 votes164 views3 answers
Init dictionary c#
C#