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 vote181 views1 answer
Error inflating class android.support.constraint.ConstraintLayout
C#
1 vote297 views2 answers
String to xml c#
C#
0 vote184 views1 answer
Asp.net mvc get current url in view
C#
10 votes223 views2 answers
C# get file size in bytes
C#
0 vote199 views1 answer
Minimize maximize restore wpf buttons
C#
0 vote249 views1 answer
Unity stop all audio
C#Unity
2 votes197 views1 answer
Unity player look at mouse
C#
11 votes222 views3 answers
C# unity detect any keyboard input
C#Unity
1 vote186 views1 answer
How to pause in unity for debug
C#
81 votes254 views5 answers
String to date
C#