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

37 votes189 views3 answers
Debug.log unity
C#
0 vote166 views1 answer
Asp.net stop page jumping to top on click
C#
0 vote183 views1 answer
Or c#
C#
41 votes172 views5 answers
How to print in c#
C#
0 vote187 views1 answer
C# random hash
C#
2 votes182 views1 answer
C# round number down
C#
0 vote168 views3 answers
F# list map function
C#
0 vote197 views1 answer
How to add rigidbody in unity
C#
5 votes177 views1 answer
C sharp if string equals
C#
10 votes173 views2 answers
Forech unity
C#