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

0 vote299 views1 answer
C# gridview summary item displayformat
C#
3 votes296 views1 answer
Invoke once on update unity
C#
0 vote287 views1 answer
C# substring reverse
C#
1 vote305 views1 answer
Shallow copy vs deep copy c#
C#
0 vote277 views1 answer
Music file explorer c#
C#
1 vote299 views1 answer
C# read text file separated by comma
C#
0 vote310 views1 answer
C# decimal to fixed 2
C#
16 votes351 views2 answers
Unity destroy
C#Unity
0 vote303 views1 answer
Google sheets problems cell not considered even
C#
1 vote286 views2 answers
Declare enum c#
C#