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

10 votes160 views2 answers
How to set a color of text in unity 2020 script
C#
0 vote183 views1 answer
How to invoke an AWS Lambda function asynchronously
C#
0 vote172 views1 answer
Why is c# say ; expected
C#
0 vote162 views2 answers
List array
C#
2 votes336 views1 answer
Change array size in unity
C#Unity
-1 vote180 views1 answer
Substring c#
C#
0 vote172 views1 answer
C# JOSN Array Conversion
C#
34 votes168 views6 answers
Console WriteLine
C#
14 votes176 views2 answers
Play animation through script unity
C#
0 vote211 views1 answer
Mvc c# return renderPartial
C#