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 vote361 views1 answer
Unity load current scene
C#
0 vote370 views1 answer
Smooth Sentences c#
C#
0 vote344 views1 answer
Wpf richtextbox clear text
C#
-1 vote335 views1 answer
Access audio source from gameobject unity
C#
0 vote380 views1 answer
Remove compoennt unity
C#Unity
1 vote369 views1 answer
Simple time c#
C#
20 votes358 views3 answers
Player movement unity 3d script
C#Unity
1 vote315 views1 answer
Wpf scrollviewer mouse wheel
C#
3 votes366 views1 answer
Difference between public and serializefield unity
C#
0 vote333 views1 answer
C# redirecttoaction with area
C#