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 vote132 views1 answer
Remove all non number in c#
C#
1 vote136 views2 answers
C# regex to find number between parenthesis
C#
0 vote157 views1 answer
C# return propertty from each object in object lpist
C#
0 vote130 views1 answer
How to get user control dropdown value in asp net
C#
0 vote123 views1 answer
Type already defines a member called 'Get'
C#
1 vote180 views1 answer
How to make a specific scene load only on game start in unity
C#Unity
0 vote110 views1 answer
C# create array with n elements
C#
21 votes139 views4 answers
C# join string array
C#
0 vote163 views1 answer
Unity sprite blurry when far
C#Unity
7 votes128 views1 answer
C# void
C#