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 vote133 views1 answer
Unity dontdestroyonload
C#Unity
4 votes112 views1 answer
How to set a vector 3 variable in csharp
C#
0 vote123 views2 answers
Install nuget package for S3
C#
0 vote150 views1 answer
What is unity3D
C#Unity
1 vote126 views1 answer
How to index ireadonlycollection c#
C#
0 vote137 views1 answer
Unity normalize movement
C#Unity
0 vote119 views1 answer
C# create delegate type at runtime
C#
0 vote111 views1 answer
Connection string .net core
C#
2 votes103 views1 answer
How to get specific length of row in matrix c#
C#
1 vote138 views1 answer
Togl unity
C#Unity