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 vote321 views1 answer
Get item from icollection
C#
2 votes331 views1 answer
C# connection string
C#
1 vote337 views1 answer
C# add time to datetime
C#
0 vote332 views2 answers
Component dynamic vue
C#
1 vote313 views1 answer
C# loop through files in folder
C#
6 votes345 views1 answer
Unity call function on animation finish
C#Unity
9 votes361 views1 answer
Unity get layer of gameobject
C#Unity
4 votes380 views1 answer
Unity check when clicked on object
C#Unity
3 votes336 views2 answers
C# move files from one directory to another
C#
0 vote318 views1 answer
Wpf binding object get value
C#