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 vote196 views1 answer
Can't select ui in scene view unity
C#Unity
0 vote177 views2 answers
Get index of item unity
C#Unity
-2 votes183 views1 answer
C# get folder of full ilepath
C#
0 vote183 views1 answer
C# execute run control panel
C#
1 vote167 views1 answer
Unity C# catch index out or range exception
C#
0 vote184 views1 answer
Return stream from file c#
C#
0 vote188 views1 answer
Delete multiple queues rabbitmq terminal
C#
2 votes176 views1 answer
When was the third world war
C#
0 vote178 views1 answer
C# object to dictionary
C#
0 vote178 views1 answer
C# get executing method name
C#