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 vote261 views2 answers
C sharp type in word and calculate how much a letter is inside that word
C#
4 votes254 views3 answers
Unfreeze position in unity
C#Unity
1 vote261 views1 answer
C# socket bind to localhost
C#
21 votes234 views3 answers
How to pause your game unity
C#
0 vote247 views2 answers
For c#
C#
0 vote229 views1 answer
Devexpress spreadsheet document source wpf
C#
0 vote236 views1 answer
C# ignore enter key
C#
1 vote238 views2 answers
C# convert bitmap to image
C#
0 vote271 views1 answer
Rename join table in many to many
C#
0 vote260 views1 answer
Pyqt icon in tab
C#