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 vote213 views1 answer
How to show a reference in unity
C#Unity
9 votes207 views2 answers
How to change textMesh Pro unity
C#
0 vote212 views1 answer
How to check type c#
C#
0 vote254 views1 answer
How to lerp a value in unity
C#Unity
12 votes213 views2 answers
Move towards target unity
C#Unity
0 vote240 views1 answer
Remove numericUpDown arrows
C#
1 vote236 views2 answers
Uncaught TypeError: $(...).validate is not a function
C#
1 vote203 views1 answer
C# sort array
C#
4 votes197 views1 answer
Unity how to set rigidbody velocity
C#
0 vote233 views1 answer
C# if statement no braces
C#