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 vote95 views1 answer
System.net.mail send html message
C#
0 vote106 views2 answers
Array reduce c#
C#
46 votes102 views6 answers
C# list
C#
3 votes125 views1 answer
Unity set sprite transparency
C#Unity
2 votes96 views1 answer
C# list.foreach
C#
0 vote101 views1 answer
C# 9.0 dynamic nedir
C#
0 vote101 views1 answer
Dapper Get List
C#
1 vote60 views2 answers
System.data.sqlclient.sqlexception
C#
12 votes114 views2 answers
C# pick a random item from array
C#
0 vote100 views1 answer
Add spaces in string
C#