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

1 vote199 views1 answer
Unity character controller ignore collision
C#Unity
3 votes139 views1 answer
Difference two list c#
C#
0 vote144 views3 answers
Change physics material unity
C#Unity
5 votes118 views4 answers
How to decrease velocity of a Unity rigidbody
C#Unity
1 vote109 views1 answer
How to center text in console application
C#
0 vote111 views2 answers
FiveM pc key code
C#
0 vote116 views1 answer
C# and Arrow Keys
C#
2 votes108 views1 answer
Get position of gameobject unity
C#
1 vote115 views1 answer
How to write a variable in console c#
C#
0 vote110 views1 answer
Count the Number of Duplicate Characters
C#