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 vote124 views1 answer
Pass viewbag using ienumerable
C#
2 votes139 views4 answers
The request was aborted: Could not create SSL/TLS secure channel.
C#
0 vote132 views1 answer
Windows forms webbrowser goforward
C#
0 vote142 views1 answer
Instantiate an object at a certain position unity
C#
30 votes164 views4 answers
Unity wait for seconds
C#Unity
0 vote148 views1 answer
Get client ip address c#
C#
0 vote140 views1 answer
"??" in C#
C#
0 vote139 views1 answer
C# getdecimal null
C#
0 vote146 views1 answer
Web page search c#
C#
0 vote160 views1 answer
C# place all keys in dictionary into array
C#