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 vote228 views1 answer
Unity set sprite image from script
C#
9 votes243 views3 answers
C# round number
C#
11 votes184 views1 answer
Mouse 2d unity
C#
-1 vote230 views2 answers
Indexof c#
C#
3 votes262 views1 answer
Bit in sql server c#
C#
0 vote229 views1 answer
How to check for file lock?
C#
0 vote247 views1 answer
C# tutorial
C#
0 vote225 views1 answer
How to make rabbitmq start and stop base on c# services
C#
6 votes243 views1 answer
Function on animation exit unity
C#Unity
0 vote212 views1 answer
C# make file writable
C#