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 vote139 views1 answer
How to search for a string from readline in c#
C#
0 vote118 views1 answer
C# drive info
C#
0 vote124 views4 answers
Check list exist in list c# if matches any
C#
0 vote128 views1 answer
Asp.net throw unauthorized exception
C#
0 vote123 views1 answer
How to make a block disappear in unity
C#
0 vote167 views2 answers
AudioSource unity
C#Unity
0 vote133 views1 answer
Circle button android
C#
1 vote129 views1 answer
NET Framework 4.7.1 or a later update is already installed on this computer.
C#
11 votes123 views2 answers
C# inline if
C#
1 vote125 views1 answer
C# public static string
C#