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

6 votes186 views6 answers
C# for loop
C#
0 vote212 views2 answers
Dynamic c# .add
C#
4 votes184 views1 answer
F string C#
C#
0 vote244 views1 answer
Input field to float unity
C#Unity
5 votes205 views3 answers
Substring c# after character
C#
95 votes201 views6 answers
C# string reverse
C#
7 votes208 views3 answers
C# string to bool
C#
8 votes190 views1 answer
C# textboxaccept only numbers
C#
0 vote151 views1 answer
Acrylic UWP Title bar C#
C#
0 vote160 views1 answer
Canceltion token c#
C#